Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

what does the second @@error return? Expand / Collapse
Author
Message
Posted Wednesday, March 21, 2012 5:33 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 2,901, Visits: 2,927
@@error will have the right error code if selected immediately after raiserror command

raiserror('oh no, another error!', 16,1)
select @@error

Thanks




Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1270564
Posted Friday, February 1, 2013 5:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 3:00 AM
Points: 252, Visits: 225
Previous question also same like this.... easy only.....





Manik
Go fast as possible






Manik
You cannot get to the top by sitting on your bottom.
Post #1414607
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse