2012. 4. 23. 17:42
MSSQL
특정 SP 검색
Declare @SP_NAME varchar(1000)
Declare @DS_TEXT varchar(1000)
Set @SP_NAME = 'order'
Set @DS_TEXT = 'order'
Select A.name, b.text, *
From sysobjects a, syscomments b
Where a.id=b.id
And a.name like '%'+@SP_NAME+'%'
And b.text like '%'+@DS_TEXT+'%'
Declare @DS_TEXT varchar(1000)
Set @SP_NAME = 'order'
Set @DS_TEXT = 'order'
Select A.name, b.text, *
From sysobjects a, syscomments b
Where a.id=b.id
And a.name like '%'+@SP_NAME+'%'
And b.text like '%'+@DS_TEXT+'%'