Posting Yak Master
Posted - 03/01/2013 : 12:58:07
| using .NET here and also SPROCS
if in a SPROC, an insert fails, I want to be able to rollback that transaction so none of the inserts are commited but also still raise an error back to .NET
how can I do this?
INSERT INTO [Table] (cols) VALUES (vals)
INSERT INTO [Table2] (COLS) VALUES (@vals) -- error raised
I want to rollback the data insert into the previous inserts but still raise an error back (same original error)