Thursday, 19 February 2015

automatic inserted in sql tables multiple rows

automatic inserted in sql tables multiple  rows :


automatic inserted in sql tables multiple  rows :


declare @id int 
select @id = 1
while @id >=1 and @id <= 50
begin
insert into [sample] values ('c' +convert(varchar(5),@id)+'@gmail.com','123')
   print 'c' +convert(varchar(5),@id)+'@gmail.com
    select @id = @id + 1
end

No comments:

Post a Comment