摘要：
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 阅读全文
posted @ 2017-11-09 19:04
Thinking.N
阅读(234)
评论(0)
推荐(0)
摘要：
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... 阅读全文
posted @ 2017-02-23 16:11
Thinking.N
阅读(3566)
评论(0)
推荐(0)
摘要：
class Program { static void Main(string[] args) { UserSearchRequest model = new UserSearchRequest() { Name = "'1'=0", Age =... 阅读全文
posted @ 2016-12-13 16:34
Thinking.N
阅读(5548)
评论(0)
推荐(0)
摘要：
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... 阅读全文
posted @ 2016-10-17 15:07
Thinking.N
阅读(7797)
评论(0)
推荐(0)
摘要：
直接上代码 阅读全文
posted @ 2016-09-27 10:37
Thinking.N
阅读(507)
评论(0)
推荐(0)
摘要：
在ASP.NET Application中加入某个定时任务，那想必一定是用一个线程在不停地做定时计算，在自己的ASP.NET应用程序中加入了Quartz.NET框架夜间或者网站在经过无访问阶段后，后台调度的线程和计算任务都停止了，如果你抓取了Application_End事件，会发现这个事件居然被调 阅读全文
posted @ 2016-04-26 15:22
Thinking.N
阅读(586)
评论(0)
推荐(0)
摘要：
class Program { static void Main(string[] args) { int totalLineCount = 0; string directory; if(args.... 阅读全文
posted @ 2015-12-14 21:30
Thinking.N
阅读(2045)
评论(0)
推荐(0)
摘要：
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... 阅读全文
posted @ 2015-12-10 10:57
Thinking.N
阅读(565)
评论(0)
推荐(0)
摘要：
1 DECLARE @Name NVARCHAR (50) 2 SET @Name = '\EXAM\061023478874' 3 4 DECLARE @Position INT 5 6 --sql first indexof 7 SET @Posit... 阅读全文
posted @ 2015-12-03 10:48
Thinking.N
阅读(701)
评论(0)
推荐(0)
摘要：
EXEC sp_rename 'TableName.[ColumnName]','ColumnNew','COLUMN' 阅读全文
posted @ 2015-11-24 09:59
Thinking.N
阅读(2932)
评论(0)
推荐(0)
浙公网安备 33010602011771号