摘要:
--表修改时间SELECT name,crdate,refdate FROM SYSOBJECTS WHERE XTYPE='U' order by refdate descselect name,create_date,modify_date from sys.tables ORDER BY mo 阅读全文
摘要:
查询存储过程时间 select * from sys.procedures ORDER BY modify_date DESC 阅读全文
摘要:
--SQL查询每个表的字段数量select b.[name], count(*) As AllCount,ISNULL(ISNULL(sum(case when isnullable=0 then 1 end),null),null) as NotNullCountfrom syscolumns a 阅读全文
摘要:
SQL Server 表,记录 死锁解决办法 1. 先根据以下语句 查询 哪些表被 死锁,及 死锁的 spid SELECT request_session_id spid,OBJECT_NAME(resource_associated_entity_id)tableName FROM sys.dm 阅读全文