Use \u6570\u636e\u5e93
\nDECLARE @ProcName varchar(50)
\nCreate Table #tmpName(Content varchar(2000))
\nCreate Table #tmp(ProcName varchar(2000),Content1 varchar(8000))
\n–\u5b9a\u4e49\u4e00\u4e2a\u6e38\u6807
\nDECLARE SearchProc CURSOR FOR
\n–\u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u5b58\u50a8\u8fc7\u7a0b\u7684\u540d\u79f0\uff0c\u5c3d\u91cf\u53bb\u9664\u7cfb\u7edfPROC\uff0c\u53ef\u4ee5\u6839\u636ecrdate\u65f6\u95f4\u5b57\u6bb5\u6765\u5bfb\u627e\u975e\u7cfb\u7edfPROC
\nselect name from sysobjects where type=’P’ and name not like ‘dt_%’
\nOPEN SearchProc
\nFETCH NEXT FROM SearchProc
\nINTO @ProcName<\/p>\n
WHILE @@FETCH_STATUS >=0
\nBEGIN
\nPrint @ProcName
\nInsert Into #tmpName(Content) Exec sp_helptext @ProcName
\nInsert Into #tmp(ProcName,Content1) select @ProcName,#tmpName.Content from #tmpName
\n–\u586b\u5145\u5b8c\u5c31\u6e05\u7a7a\u4e00\u4e0b\u4e34\u65f6\u8868
\nTruncate table #tmpName
\nFETCH NEXT FROM SearchProc
\nINTO @ProcName
\nEND
\nCLOSE SearchProc
\nDEALLOCATE SearchProc
\nGO<\/p>\n
select ProcName from #tmp where Content1 like ‘%\u67e5\u627e\u5185\u5bb9%’ group by ProcName<\/p>\n
select ProcName,Content1 from #tmp where Content1 like ‘%\u67e5\u627e\u5185\u5bb9%’<\/p>\n
select ProcName,Content1 from #tmp where procname=’\u5b58\u50a8\u8fc7\u7a0b\u540d\u79f0’
\n–\u5220\u9664\u4e34\u65f6\u8868
\nDrop Table #tmpName
\nDrop Table #tmp<\/p>\n","protected":false},"excerpt":{"rendered":"