摘要:
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%' 方法二: 阅读全文