mssql 循环查找存储过程SP中的指定文本

 SELECT CONVERT(NVARCHAR(255),'') SPName,CONVERT(NVARCHAR(255),'') DBName INTO #tempQuery

 TRUNCATE TABLE #tempQuery

DECLARE @DBname VARCHAR(20)--声明 
DECLARE curdbname CURSOR FOR SELECT Name FROM Master..SysDatabases ORDER BY Name --创建游标
OPEN curdbname --打开游标
FETCH NEXT FROM curdbname INTO @DBname --给游标赋值
WHILE @@FETCH_STATUS=0 --判断FETCH语句是否执行执行成功
BEGIN

 
EXEC ('use '+@DBname+'  ;insert into #tempQuery SELECT DISTINCT o.name,'''+@DBname+''' as uu FROM sysobjects o JOIN syscomments c ON c.id = o.id AND o.type=''P''
 WHERE c.text LIKE ''%''''SFE''''%''')
PRINT ('use '+@DBname+'  ;insert into #tempQuery SELECT DISTINCT o.name,'''+@DBname+''' as uu FROM sysobjects o JOIN syscomments c ON c.id = o.id AND o.type=''P''
 WHERE c.text LIKE ''%''''SFE''''%''')  --验证脚本
FETCH NEXT FROM curdbname INTO @DBname --下一个值
END
CLOSE curdbname --关闭游标
DEALLOCATE curdbname --释放游标

老项目上百个存储过程,找指定文本,mark 下,下次可以直接找,不再手写了,我找的是'SFE'  含有'