开发者

Bulk Insert multiple records and get identity for all using ADO.NET

开发者 https://www.devze.com 2022-12-27 17:42 出处:网络
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.

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号