摘要： -- 在数据库存储过程中查找文本字符（检索存储过程内容）SELECT DISTINCT o.name AS Object_Name,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id=o.object_id WHERE m.definition Like '%key%' ORDER BY 2,1-- 强制写入自增长字段SET IDENTITY_INSERT [KeyLookup] ON INSERT INTO table(KeyID, Value) Values(1, 123)SE 阅读全文