SQLServer 内容检索

declare @str varchar(100)
 set @str='复合信用控制'
 
declare @s varchar(8000)
 declare tb cursor local for
 select s='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')
 print ''所在的表及字段: ['+b.name+'].['+a.name+']'''
 from syscolumns a join sysobjects b on a.id=b.id
 where b.xtype='U' and a.status>=0
 and a.xusertype in(175,239,231,167)
 open tb
 fetch next from tb into @s
 while @@fetch_status=0
 begin
 exec(@s)
 fetch next from tb into @s
 end
 close tb
 deallocate tb