Bulk Insert multiple records and get identity for all using ADO.NET
I want to batch insert multiple records in sql server database using ADO.NET command/sqldataadapter and get 开发者_JAVA百科identity value generated for all the rows in a single database trip.
What are my options?
If you're using either, SQL server 2005 and 2008 add support for the OUTPUT clause, which enables you to return a result-set from an UPDATE/INSERT/DELETE statement.
精彩评论