sql²éѯËùÓд洢¹ý³ÌÄÚÈÝ ÀûÓÃÓαêºÍÁÙʱ±í

Use Êý¾Ý¿â
DECLARE @ProcName varchar(50)
Create Table #tmpName(Content varchar(2000))
Create Table #tmp(ProcName varchar(2000),Content1 varchar(8000))
--¶¨ÒåÒ»¸öÓαê
DECLARE SearchProc CURSOR FOR
--²éѯÊý¾Ý¿âÖд洢¹ý³ÌµÄÃû³Æ£¬¾¡Á¿È¥³ýϵͳPROC£¬¿ÉÒÔ¸ù¾Ýcrdateʱ¼ä×Ö¶ÎÀ´Ñ°ÕÒ·ÇϵͳPROC
select name from sysobjects where type='P' and name not like 'dt_%'
OPEN SearchProc
FETCH NEXT from SearchProc
INTO @ProcName
WHILE @@FETCH_STATUS >=0
BEGIN
    Print @ProcName
    Insert Into #tmpName(Content) Exec sp_helptext @ProcName
    Insert Into #tmp(ProcName,Content1) select @ProcName,#tmpName.Content from #tmpName
    --Ìî³äÍê¾ÍÇå¿ÕÒ»ÏÂÁÙʱ±í
    Truncate table #tmpName
    FETCH NEXT from SearchProc
    INTO @ProcName
END
CLOSE SearchProc
DEALLOCATE SearchProc
GO
select ProcName from #tmp where Content1 like '%²éÕÒÄÚÈÝ%' group by ProcName
select ProcName,Content1 from #tmp where Content1 like '%²éÕÒÄÚÈÝ%'
select ProcName,Content1 from #tmp where procname='´æ´¢¹ý³ÌÃû³Æ'
--ɾ³ýÁÙʱ±í
Drop Table #tmpName
Drop Table #tmp