摘要：DECLARE @spid nvarchar(100)DECLARE Info_cursor CURSOR FORselect spid from (SELECT TEXT astt,AA.* FROM sys.sysprocessesAA CROSS APPLYsys.dm_exec_sql_text(AA.sql_handle)) as awhere login_time >DATEADD(MI,-30,getdate())and last_batch >DATEADD(SECOND,2,login_time)and loginame <> 'sa' 阅读全文

摘要：declare @tableName varchar(500),@columns varchar(500)set @tableName='TestBatch'set @columns= '2'set nocount ondeclare @cols table (id int)while(CHARINDEX(',',@columns)>0)begin insert into @cols select CAST(SUBSTRING(@columns,1,CHARINDEX(',',@columns)-1) AS int) set 阅读全文

摘要：select * from (SELECT TEXT astt,AA.* FROM sys.sysprocessesAA CROSS APPLYsys.dm_exec_sql_text(AA.sql_handle)) as awhere login_time >DATEADD(MI,-30,getdate())and last_batch >DATEADD(SECOND,2,login_time)and loginame <> 'sa'and loginame not like 'tcdb%'and loginame not like & 阅读全文

摘要：WITH ProcessCTE(blocked) AS(SELECT blocked from (SELECT TEXT as tt,AA.* FROM sys.sysprocesses AA CROSS APPLY sys.dm_exec_sql_text(AA.sql_handle)) as a where tt like '%XXXX%' and tt not like '%TEXT as tt,%' and blocked>0)SELECT a.* FROM ( SELECT TEXT,AA.* FROM sys.sysprocesses AA C 阅读全文

摘要：一、环境说明：挑选两台不同系统的电脑测试（XP、Win7、Server2008、Server2003全可）。本例环境如下本地系统-Win7，数据库名称localTest，IP为192.168.0.102远端系统-XP，数据库名称Test131，IP为192.168.57.131二、存储过程创建表Sql代码USE[localTest]GO/******Object:Table[dbo].[City]ScriptDate:06/26/201119:37:49******/SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATETABLE[dbo].[City] 阅读全文

摘要：SqlCommand.Parameters其实是用的存储过程sp_executesql 阅读全文

摘要：一、declare @d datetimeset @d=getdate()select top 1 id,***,***,***from *** as t2 with (nolock) where t2.*** = '***' and t2.*** = '***' and t2.*** = '***' AND t2.***>-1select [语句执行花费时间(毫秒)]=datediff(m... 阅读全文