DECLARE @tbl nvarchar(128)
DECLARE @sql nvarchar(128)
SET NOCOUNT ON
--生成与用户信息表结构相同的表
SELECT * INTO #TEMP FROM user040101 WHERE 1=2
DECLARE cur_tbl cursor local for
SELECT 'insert into #TEMP SELECT * FROM '+NAME+' WHERE NAME LIKE ''王%''' FROM SYSOBJECTS WHERE XTYPE='U' and name like 'USER04%'
OPEN cur_tbl
FETCH NEXT FROM cur_tbl INTO @sql
WHILE @@fetch_status =0
BEGIN
EXEC(@sql)
FETCH NEXT FROM cur_tbl INTO @sql
END
CLOSE cur_tbl
DEALLOCATE cur_tbl
SELECT * FROM #TEMP
DROP TABLE #TEMP