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
SQL检查存储过程是否包含关键字
最新推荐文章于 2024-03-12 10:58:29 发布