sql通过游标遍历某个数据库中所有的表,按某种需求筛选出对应的记录
运行环境: SQL SERVER
DECLARE @Name nvarchar(255),@Sql nvarchar(4000)
DECLARE TName CURSOR FOR
SELECT [name] FROM sysobjects WHERE xtype = 'U'
OPEN TName
FETCH NEXT FROM TName INTO @Name
WHILE @@FETCH_STATUS = 0
BEGIN
SET @Sql='SELECT TOP 2 * FROM ['+@name + '] WHERE 1=1
-- 这里还可以拼其它你想要的过滤条件
'
EXEC(@Sql)
FETCH NEXT FROM TName INTO @name
END
CLOSE TName
DEALLOCATE TName