Question

sql server中语句变量自增

在sql server中要像其它的编程语句一样实现类似的功能，既每循环一次不就自动加一，sql server中怎么不行啊，怎样才能实现呢？
declare @i int
set @i=3
while @i<10
insert into student(id,name,email) values(@i,'er','we.f')
@i = @i+1

Answer 1

while循环要加上begin end
@i = @i+1 要改为 set @i = @i+1

Answer 2

declare @i int
set @i=3
while @i<10
begin
insert into student(id,name,email) values(@i,'er','we.f')
set @i = @i+1
end

Answer 3

while后面的循环要加上begin end

Answer 4

set @i = @i+1