开发者

SQL Server 2008 search

How to search inside a Stored Procedure in SQL Serve开发者_高级运维r 2008?


If you are looking for the searching for specific key in definiton of a stored procedure use INFORMATION_SCHEMA.ROUTINES along with OBJECT_DEFINITION function.

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE OBJECT_DEFINITION( OBJECT_ID(SPECIFIC_NAME)) LIKE '%<YOUR_KEY>%'
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜