存储过程查询 select a.name,b.text from sys.procedures a left join sys.syscomments b on a.object_id = b.id where b.text like '%demo.dbo.rfi_startopr%' 视图查询 select a.name,b.text from sys.views a left join sys.syscomments b on a.object_id
存储过程查询
select a.name,b.text from sys.procedures a left join sys.syscomments b on a.object_id = b.id where b.text like '%demo.dbo.rfi_startopr%'
视图查询
select a.name,b.text from sys.views a left join sys.syscomments b on a.object_id = b.id where b.text like '%coptd%'
create table #proc 
(
procname varchar(200),
content varchar(max) 
)
declare @procname varchar(200)
declare @temp varchar(max) 
declare selectproc  cursor  scroll for
select name from sys.procedures 
open selectproc
fetch next from selectproc into @procname 
while @@fetch_status = 0
begin
exec @temp = sp_helptext [proc_mulkey_save_multioperqty]
print @temp
insert #proc ( procname, content )
values  ( @procname, @temp )  
fetch next from selectproc into @procname 
end
close selectproc
deallocate selectproc
select * from #proc where content like '%demo.dbo.rfi_startopr%'
--drop table #proc
，网站空间，香港空间，香港虚拟主机