wzc900810的专栏

declare @str varchar(100) set @str='111'  --要搜索的字符串   declare @s varchar(8000) declare tb cursor local for     select 'if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')

EXEC SP_CONFIGURE 'show advanced options',1 RECONFIGURE EXEC SP_CONFIGURE 'Ad Hoc Distributed Queries',1 RECONFIGURE    insert into openrowset('sqloledb','192.168.2.87';'sa';'yfb123?',portalzeus_