查找sp sql

create Procedure [dbo].[sp_LookForSP]( @DatabaseName VarChar(100) , @KeyWord1 VarChar(100), @KeyWord2 VarChar(100), @KeyWord3 VarChar(100) ) As Declare @SQL VarChar(8000) Set NoCount On If @DatabaseName = '' Begin Select Null NullRef Return End If Not Exists (Select * From SysDatabases Where Name = @DatabaseName ) Begin Select 'Database not found !!!' Result Return End set @KeyWord1=replace(@KeyWord1,'^','''''') set @KeyWord2=replace(@KeyWord2,'^','''''' set @KeyWord3=replace(@KeyWord3,'^','''''') Select @SQL = ' Select ''' + @DatabaseName + ''' DBName , A.Name ProcName , Convert(VarChar(19),A.CRDate, 120) CreateDate , Convert(VarChar(19) , A.RefDate , 120) RefDate From [' + @DatabaseName + ']..SysObjects A , [' + @DatabaseName + ']..SysComments B Where A.id = B.ID And B.Text Like ''%' + @KeyWord1 + '%'' And B.Text Like ''%' + @KeyWord2 + '%'' And B.Text Like ''%' + @KeyWord3 + '%'' Order By A.Name ' Exec (@SQL)