情况是这样的,我建了一个A表,里边有十条数据; ...... declare @i int set @i = 0 select @i=@i+1 from A print @i ..... 在执行以上语句时,有时候最后@i的值是10,有时候是1;为什么赋值有时候循环10次,有时候只循环一次呢?本人百思不解!!!!!!!!!!!!!!!
insert t select 1
union select 2
union select 3
union select 4
union select 5
union select 6
union select 7
union select 8
union select 9
union select 10
declare @i int
set @i = 0
select @i=@i+1
from t
print @i
----结果
10
declare @t table(a int)
insert @t
select 2 union all
select 2 union all
select 2 union all
select 2 union all
select 2 union all
select 2 union all
select 2 union all
select 2 union all
select 2 union all
select 2
declare @i int
set @i = 0
select @i=@i+1
from @t
print @i