I want to insert multiple records to a table in bulk and I want the whole operation to fail(rollback) if one of the inserts has an error .how do I go about this ?
Please refer below links
http://stackoverflow.com/questions/2216254/rollback-for-bulk-copy
http://stackoverflow.com/questions/41869/is-sql-server-bulk-insert-transactional
I hope this will help you out.
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.