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

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

Edit
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.