DECLARE @tabname NVARCHAR(50)
DECLARE @colname NVARCHAR(50)
DECLARE mycursor CURSOR FOR
SELECT so.[name],sc.name
FROM sysobjects so
INNER JOIN syscolumns sc ON (so.id=sc.id)
WHERE so.xtype='U' AND sc.name LIKE '%user%'
AND so.NAME NOT LIKE 'Audit%'
OPEN mycursor
FETCH NEXT FROM mycursor INTO @tabname,@colname
WHILE(@@FETCH_STATUS=0)
BEGIN
--PRINT 'select * from '+@tabname+' where '+@colname+' like ''%IamV%'' '
EXEC('select * from '+@tabname+' where '+@colname+' like ''%IamV%'' ')
IF @@ROWCOUNT>0
BEGIN
PRINT @tabname
END
FETCH NEXT FROM mycursor INTO @tabname,@colname
END
CLOSE mycursor
DEALLOCATE mycursor
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。