查找数据库中包含某段字符的存储过程语句,今天跟DBA学的,记下来吧
select name from sys.procedures a join sys.syscomments b on a.object_id=b.id where b.text like '%xxxxx%'
select name from sys.procedures a join sys.syscomments b on a.object_id=b.id where b.text like '%xxxxx%'