Wednesday, June 3, 2009

SQL Server - How to Bulk Insert data into a table with Identity Column?

If you need to bulk insert data (in an application or a sql query) into some table with identity column,there is a simple solution:
Create View without the Identity column and bulk insert data into that view
instead of the table.
This method is working fine in SQL Server 2000/2005/2008.

No comments:

Post a Comment