declare @i int,@a varchar(10)set @i = 0set @a='hiro--'+LTRIM(@i)while @i < 500begin insert into hiro values(@a,GETDATE()); set @i = @i + 1 set @a='hiro--'+LTRIM(@i)end