Thursday, February 16, 2012

Checking for @@ERROR after a SELECT inside a transaction?

Is it normal practice to check for @.@.ERROR after a SELECT statement that retrieves data from a table OR we should only check for @.@.ERROR after a DELETE/INSERT/UPDATE type of statement?The SQL statement is inside a transaction.SELECT statements can return an error. Just do a find on this page for "error".

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp

No comments:

Post a Comment