Insert of T-SQL

1. Insert basic syntax:

Insert [into] <Table>

[(<Column list>)]

Values (<data values>) [, (<data values>)] [,... n]

 

2. Insert multiple rows (new feature of SQL 2008)

Insert into sales

(Storecode, ordernumber, orderdate)

Values

('Tst1', 'storder1', '2014/1/123 '),

('Tst1', 'storder2', '2014/1/123 ');

 

3. insert into <Table Name>

(<Column list>)

<SELECT statement>

Note: <Table Name> must exist in the database or be stated in advance.

Use adventureworks2008

Declare @ mytable table

(

Salesorderid int,

Customerid char (5)

);

Insert into @ mytable

Select salesorderid, customerid

From adventureworks2008.sales. salesorderheader

Where salesorderid between 44000 and 44010;

 

Select * From @ mytable;