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