January 20th, 2009, 02:11 AM
|
|
Contributing User
|
|
Join Date: May 2006
Posts: 763
Time spent in forums: 2 Days 3 h 52 m
Reputation Power: 4
|
|
|
RAISEERROR problem
Hello everyone,
If in a store procedure, it is using SET XACT_ABORT ON (auto rollback transaction when there is error). Currently, I just rely on the output of the store procedure (when there is any errors inside) to handle success/error at client side (e.g. ADO.Net client), now I want to add RAISEERROr statement to throw the error outside to client. But I can not think of how to add RAISEERROR and fill in the related parameters for this function. Does anyone have any ideas?
Here is my pseudo code.
Code:
SET XACT_ABORT ON;
-- DML operations
commit;
thanks in advance,
George
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
