查询含某一字符串的存储过程的SQL语句

2025-03-23 08:03:24
推荐回答(1个)
回答1:

sql server2005环境
SELECT object_name(object_id)
FROM sys.sql_modules where definition like '%abc%'
sqlserver 2000环境
select object_name(id) from syscomments
where number=1 and text like '%abc%'