SQL server 的while循环的数据插入训练
create table emp(id int
,empno varchar(10)
)
declare @id int,@empno varchar(10)
set @id = 0
– 开始循环,设置1000条数据插入
while @id < 1000
begin
set @id = @id +1
set @empno = right(‘0000’ + cast(@id as varchar(10)),4)
insert into emp values(@id,@empno)
end;
select * from emp; – 查询数据是否插入进来了
drop table emp;