Insert into DB 1

[dhmfh]

Hi Guys

I want to insert 10 records into a db table. Is there a better way of doing this rather than writing 10 insert statements. If so can you point me in the right direction

Kind regards

 

[bborissov]

W/o knowing what you will insert it is hard to me to say what is better way ;-)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[dhmfh]

will be inserting 10 records into a new table based on an Id

insert into table (id, value)
values (1,1)
insert into table (id, value)
values (1,2)
insert into table (id, value)
values (1,3)
insert into table (id, value)
values (1,4)
insert into table (id, value)
values (1,5)

and so on.

Hope that helps

 

[bborissov]

If this is the actual replace (I doubt it)

DECLARE @i int
SET @i = 0
WHILE @i < 11
      BEGIN
         SET @i = @i +1
         INSERT INTO Table (id, value) values (1,@i)
      END

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.