Monday, October 19, 2009

MS SQL Server : Bulk Insert

Two ways for bulk insert in MS SQL Server:
1) select au_fname +','+ au_lname as autName into tempAuth from authors
Here tempAuth table should not exists in the database. so in the execution time the table will be created with the constraints of the parent table authors.
2) insert into tempAutho select au_fname +','+ au_lname as autName from authors
Here we are supposed have the table already exist with the same column constraints...

No comments: