Info-lake
Knowledge sharing....
January 4, 2012
Error Handling in SQL
Declare @Error int
set @Error = @@ERROR
if @Error = 0
set @Error = @@ERROR
IF @Error = 0
BEGIN
COMMIT tran
END
ELSE
BEGIN
ROLLBACK tran
END
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment