摘要:
SELECT obj.Name AS 存储过程名, sc.TEXT as 存储过程内容 FROM syscomments sc INNER JOIN sysobjects obj ON sc.Id = obj.ID WHERE sc.TEXT LIKE '%请输入要查找的内容%' AND TYPE 阅读全文
摘要:
insert into tb(a,b,c) select 'a','b','c' union all select 'd','e','f' union all select 'x','y','z' insert into tableName (列名1,列名2,列名3,列名4) values (值1,值2, 值3, 值4), (值1,值2, 值3, 值4), (值1,值2, 值3, 值4) ... 阅读全文
摘要:
UPDATE a SET a.nstuId=b.bStuID FROM TableA a INNER JOIN ( SELECT * FROM ( SELECT a.nTID,a.vcCtor, a.nStuID,isnull(b.nStuID,0) AS bStuID,a.dtCTime FROM 阅读全文
摘要:
SELECTA.name AS table_name,B.name AS column_name,C.value AS column_descriptionFROM sys.tables AINNER JOIN sys.columns B ON B.object_id = A.object_idLE 阅读全文
摘要:
select ,update的字段、order by 、group by 放 Include。where条件中的放on 对于关联语句中的on,当有语句有where条件时放include,当没有where时放在on DROP_EXISTING = ON 删除与创建索引名称相同的索引,可用作对索引的修改 阅读全文
摘要:
方法一: select distinct object_name(id) from syscomments where id in (select object_id from sys.objects where type ='P') and text like'%TableName%' 方法二: 阅读全文