declare @n int,@count intdeclare @TableName nvarchar(50)declare @SQL nvarchar(max)create table #TableName(ID INT IDENTITY(1,1),Name nvarchar(50))insert into #TableName select name from sysobjects where xtype='U'select @count=COUNT(*) from #TableNameset @n=1while(@n<=@count)beginselect @TableName=Name from #TableName where ID=@nset @SQL='select * into [ipVA_Apple_2].[dbo].['+@TableName+'] from [IPVA_Apple].[dbo].['+@TableName+']'exec(@SQL)set @n=@n+1endDROP TABLE #TableName
