上一页 1 2 3 4 5 6 7 ··· 19 下一页
摘要: 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 阅读(226) 评论(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 阅读(3517) 评论(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 阅读(5519) 评论(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 阅读(7756) 评论(0) 推荐(0) 编辑
摘要: 直接上代码 阅读全文
posted @ 2016-09-27 10:37 Thinking.N 阅读(495) 评论(0) 推荐(0) 编辑
摘要: 在ASP.NET Application中加入某个定时任务,那想必一定是用一个线程在不停地做定时计算,在自己的ASP.NET应用程序中加入了Quartz.NET框架夜间或者网站在经过无访问阶段后,后台调度的线程和计算任务都停止了,如果你抓取了Application_End事件,会发现这个事件居然被调 阅读全文
posted @ 2016-04-26 15:22 Thinking.N 阅读(562) 评论(0) 推荐(0) 编辑
摘要: class Program { static void Main(string[] args) { int totalLineCount = 0; string directory; if(args.... 阅读全文
posted @ 2015-12-14 21:30 Thinking.N 阅读(2009) 评论(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 阅读(556) 评论(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 阅读(696) 评论(0) 推荐(0) 编辑
摘要: EXEC sp_rename 'TableName.[ColumnName]','ColumnNew','COLUMN' 阅读全文
posted @ 2015-11-24 09:59 Thinking.N 阅读(2870) 评论(0) 推荐(0) 编辑
上一页 1 2 3 4 5 6 7 ··· 19 下一页