Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: PeaceMaker
- Content: Threads
- Order by date
-
How to handle Errors in a Stored Procedure in SQL Server 6.5
I have written a stored procedure which consists of 3000 or more lines.... Now it is in transaction... i want to rollback if any of my sql statement fails during the processing.. I want to commit only when my Stored procedure is complete I am using @@Error variable to find out whether the...- PeaceMaker
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
