如下SQL中如何解决的,谢谢

[ykwang]

我有一个变量如下语句
SET @I=1
WHILE @I<10
BEGIN
SELECT * INTO #TEMP+@I FROM ABCD
END

我想每个@I的值自生成一个表,如上是错误的,不知 #TEMP+@I 如何写? 谢谢

[hsj20041004]

declare @I int,@sql varchar(1000)
SET @I=1
set @sql=''
WHILE @I<10
BEGIN
@sql='SELECT * INTO #TEMP'+ @I +'FROM ABCD'
exec @sql
set @I=@I+1
END

[hsj20041004]

declare @I int,@sql varchar(1000)
SET @I=1
set @sql=''
WHILE @I<10
BEGIN
set @sql='SELECT * INTO #TEMP'+ @I +'FROM ABCD'
exec @sql
set @I=@I+1
END

[631799]

declare @I int,@s varchar(200)
SET @I=1
WHILE @I<10
BEGIN
select @s = 'SELECT * INTO #TEMP'+cast(@I as varchar)+' FROM ABCD'
exec @s
set @i=@i+1
END

[hsj20041004]

declare @I int,@sql varchar(1000)
SET @I=1
set @sql=''
WHILE @I<3
BEGIN
set @sql='SELECT * INTO #TEMP'+ convert(varchar,@I) +char(13)+'FROM ff_user_base_info'
print @sql
exec (@sql)
set @I=@I+1
END

[hsj20041004]

declare @I int,@sql varchar(1000)
SET @I=1
set @sql=''
WHILE @I<10
BEGIN
set @sql='SELECT * INTO #TEMP'+ convert(varchar,@I) +char(13)+'FROM ABCD
exec (@sql)
set @I=@I+1
END

[taoyb]

但是得到的数据在哪呢？

我在最后加一句： select * from #temp1 无效的！