摘要:
SELECT FK.NAME,FK.OBJECT_ID,OBJECT_NAME(FK.PARENT_OBJECT_ID) AS REFERENCETABLENAMEFROM SYS.FOREIGN_KEYS AS FKJOIN SYS.OBJECTS AS O ON FK.REFERENCED_OB 阅读全文
摘要:
SELECT TOP 50 qs.total_worker_time/qs.execution_count as [Avg CPU Time], SUBSTRING(qt.text,qs.statement_start_offset/2, (case when qs.statement_end_offset = -1 then len(convert(nvarchar(max), qt.te... 阅读全文
摘要:
class Program { static void Main(string[] args) { UserSearchRequest model = new UserSearchRequest() { Name = "'1'=0", Age =... 阅读全文
摘要:
using System; using System.Collections.Generic; using System.Text; using System.Net; using System.IO; using System.Collections.Specialized; namespace TechnetSamples { class Program { static void Mai... 阅读全文
摘要:
直接上代码 阅读全文
摘要:
在ASP.NET Application中加入某个定时任务,那想必一定是用一个线程在不停地做定时计算,在自己的ASP.NET应用程序中加入了Quartz.NET框架夜间或者网站在经过无访问阶段后,后台调度的线程和计算任务都停止了,如果你抓取了Application_End事件,会发现这个事件居然被调 阅读全文
摘要:
class Program { static void Main(string[] args) { int totalLineCount = 0; string directory; if(args.... 阅读全文
摘要:
List arr1 = new List() { 1, 2, 3, 4 };List arr2 = new List() { 4, 5, 6, 7 };var arr3 = arr1.Intersect(arr2).ToList();var arr4 = arr1.Except(arr2).ToLi... 阅读全文
摘要:
1 DECLARE @Name NVARCHAR (50) 2 SET @Name = '\EXAM\061023478874' 3 4 DECLARE @Position INT 5 6 --sql first indexof 7 SET @Posit... 阅读全文
摘要:
EXEC sp_rename 'TableName.[ColumnName]','ColumnNew','COLUMN' 阅读全文