且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Sql Server 2008 R2存储过程中搜索字符串?

更新时间:2022-11-28 14:31:17

免费 Red Gate SQL搜索?

Free Red Gate SQL Search?

或查询 sys.sql_modules

SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE definition LIKE '%=*%' OR definition LIKE '%*=%'

注意:INFORMATION_SCHEMA视图和系统注释会截断定义,因此不可靠.

Note: INFORMATION_SCHEMA views and syscomments truncate the definition so are unreliable.