如果sno是自动增量则: declare @sno int declare @sname varchar(20) set @sno=1 set @sname='名字' while @sno<=10000 begin insert student values(@sname+@sno,'女') set @sno=@sno+1 end 否则: declare @sno int declare @sname varchar(20) set @sno=1 set @sname='名字' while @sno<=10000 begin insert student values(@sno,@sname+@sno,'女') set @sno=@sno+1 end
刚才有错误: insert student values(@sname+cast(@sno as varchar),'女')
declare @sno int
declare @sname varchar(20)
set @sno=1
set @sname='名字'
while @sno<=10000
begin
insert student values(@sname+@sno,'女')
set @sno=@sno+1
end
否则:
declare @sno int
declare @sname varchar(20)
set @sno=1
set @sname='名字'
while @sno<=10000
begin
insert student values(@sno,@sname+@sno,'女')
set @sno=@sno+1
end
insert student values(@sname+cast(@sno as varchar),'女')