declare @i int
set @i=1
while @i<100
begin
insert into [User](loginName,name,password,isAdmin)
values( 'ys100'+''+ convert(varchar,@i),'医生','123456','doctor');
set @i=@i+1
end
SqlServer 循环插入数据
最新推荐文章于 2023-08-09 15:38:39 发布
declare @i int
set @i=1
while @i<100
begin
insert into [User](loginName,name,password,isAdmin)
values( 'ys100'+''+ convert(varchar,@i),'医生','123456','doctor');
set @i=@i+1
end