declare @i int,@a varchar(10)
set @i = 0
set @a='hiro--'+LTRIM(@i)
while @i < 500
begin
insert into hiro values(@a,GETDATE());
set @i = @i + 1
set @a='hiro--'+LTRIM(@i)
end
转载于:https://www.cnblogs.com/Work-hard-to-make-money/p/10392717.html
declare @i int,@a varchar(10)
set @i = 0
set @a='hiro--'+LTRIM(@i)
while @i < 500
begin
insert into hiro values(@a,GETDATE());
set @i = @i + 1
set @a='hiro--'+LTRIM(@i)
end
转载于:https://www.cnblogs.com/Work-hard-to-make-money/p/10392717.html