摘要： declare @str varchar(100)set @str='系统'declare @s varchar(max)declare c_tb cursor local for --申明游标 select b='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'') print ''select ['+a.name+'] from ['+b.name+ 阅读全文