SQL检查存储过程是否包含关键字

2014-11-24 13:18:14 · 作者: · 浏览: 0
SELECT A.NAME FROM SYS.ALL_OBJECTS A,SYS.SQL_MODULES B 
WHERE A.IS_MS_SHIPPED=0 AND A.OBJECT_ID = B.OBJECT_ID AND A.[TYPE] IN ('P','V','AF') 
AND [DEFINITION] LIKE '% %'--存储过程包含的关键字
ORDER BY A.[NAME] ASC