代码如下:declare str varchar(100) set str=’8f8el3l’ 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
