为什么会执行多次

[ylm2003]

declare @num int
set @num=1
declare cpy cursor for select name from sysobjects where xType= 'U' and category=0
open cpy
declare @oldname varchar(20)
declare @sql varchar(1000)
fetch from cpy into @oldname
while @@FETCH_STATUS=0
begin
set @sql='select top 0 * into '+ @oldname+'_'+convert(varchar(10),@num) +' from '+ @oldname
exec (@sql)
fetch from cpy into @oldname
end
close cpy
deallocate cpy

[haitao]

执行前， select name from sysobjects where xType= 'U' and category=0 的结果是多少条 执行后， select name from sysobjects where xType= 'U' and category=0 的结果是多少条

[發糞塗牆]

exec (@sql)改成print @sql，看看执行了些什么