查詢所的表中相同字段值為...的記錄1.
DECLARE @sql varchar(5000)
SET @sql=''SELECT @sql=@sql+' '+ 'SELECT * FROM ' + name + ' WHERE ip IN(''xx.yy.zz.dd'',''kjk.kk.ll.ll'')'
FROM sysobjects
WHERE (xtype = 'U')
SELECT @sql2.
EXEC sp_msforeachtable 'SELECT * FROM ? WHERE ip in(''xx.yy.zz.dd'',''kjk.kk.ll.ll'')'
DECLARE @sql varchar(5000)
SET @sql=''SELECT @sql=@sql+' '+ 'SELECT * FROM ' + name + ' WHERE ip IN(''xx.yy.zz.dd'',''kjk.kk.ll.ll'')'
FROM sysobjects
WHERE (xtype = 'U')
SELECT @sql2.
EXEC sp_msforeachtable 'SELECT * FROM ? WHERE ip in(''xx.yy.zz.dd'',''kjk.kk.ll.ll'')'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货