摘要：
CREATE TRIGGER [Object_Change_Trigger_DDL] ON database FOR DROP_TABLE AS DECLARE @EventData AS xml; SELECT @EventData = EVENTDATA(); IF @EventData.value('(/EVENT_INSTANCE/LoginName)[1]','varchar(15... 阅读全文
摘要：
use tempdb go SELECT top 10 t1.session_id, t1.internal_objects_alloc_page_count, t1.user_objects_alloc_page_count, t1.internal_objects_dealloc_pag... 阅读全文
摘要：
--通过name为NT AUTHORITY\SYSTEM的登录账号的create_date，就知道SQL Server的安装日期了。 SELECT * FROM SYS.SERVER_PRINCIPALS WHERE NAME='NT AUTHORITY\SYSTEM' 阅读全文
摘要：
DECLARE @ColumnName AS VARCHAR(100); SET @ColumnName='字段名的模糊匹配'; SELECT 表名=D.NAME, 表说明 = CASE WHEN A.COLORDER=1 THEN ISNULL(F.VALUE, ' ') ELSE ' ' END, 字段序号 = A.COLORDER, ... 阅读全文
摘要：
SELECT obj.Name 存储过程名, sc.TEXT 存储过程内容 FROM syscomments sc INNER JOIN sysobjects obj ON sc.Id = obj.ID WHERE sc.TEXT LIKE '%FN_128ENCODER%' AND TYPE = 'P' 阅读全文
摘要：
SELECT * FROM TB WHERE COL LIKE N'%[吖-咗]%' 阅读全文
摘要：
SELECT a.name,b.name,c.DATA_TYPE,b.max_length FROM sys.tables a join sys.columns b on b.object_id = a.object_id join INFORMATION_SCHEMA.COLUMNS c on b.name=c.COLUMN_NAME and a.name=c.TABLE_NAME where... 阅读全文
摘要：
SELECT OBJECT_NAME(ii.id) TableName ,rows FROM sysindexes ii INNER JOIN sysobjects oo ON ( oo.id = ii.id AND oo.xtype = 'U ') WHERE ii.indid < 2 ORDER BY rows desc ; 阅读全文