SQL to insert multiple rows of data at a time.

I. The following is a complete example of using SQL programming to insert multiple statements at a time:

Declare   @   Int , @ B   Int
Set   @ = 1
Set   @ B = 20

While   @ <= 20
Begin
Insert   Into Testtb (TID, tvalue) Values ( @ , @ B )
Set   @ = @ + 1
Set   @ B = @ B - 1
End
Select   *   From Testtb
Go

 

Ii. statement format for using insert into Table Name (Field List) Select Value List Union all select Value List:
 

Insert   Into Testtb (TID, tvalue)
Select 94 , 100 Union   All  
Select 72 , 12
Go  

III.
1. Copy data from an existing table to a new table (the table with the same structure as the old table ):
Create   Table Newtb (NID Int , Nvalue Int ) Go
Insert   Into Newtb (NID, nvalue) Select TID, tvalue From Testtb

2. Copy data from an existing table to a new table (the new table does not exist ):

 

SelectTID, tvalueIntoNewtbFromTesttb