what does the second @@error return?

Question

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply

MIGUEL PEGUERO Grasshopper Points: 16 More actions · Answer 1

Second error return 50000

(1 row(s) affected)

Msg 50000, Level 16, State 1, Line 2

oh no, error!

(1 row(s) affected)

Msg 50000, Level 16, State 1, Line 6

oh no, another error!

(1 row(s) affected)

MIGUEL PEGUERO Grasshopper Points: 16 More actions · Answer 2

Return 0 because there is a statement between (select 'xyz'), and this statement do not raise error

vk-kirov SSCertifiable Points: 7686 More actions · Answer 3

Lynn Pettis (4/26/2010)
What is interesting is that approximately a third of the respondents have gotten the question wrong.

I'm amongst that respondents because I haven't used @@error since 2006, and I've already forgotten about this function 🙂

preeti.singh SSC Journeyman Points: 80 More actions · Answer 4

Select 'xyz' will not return any error.

so @@error return 0

suryam Mr or Mrs. 500 Points: 569 More actions · Answer 5

Mr or Mrs. 500

Points: 569

May 18, 2010 at 5:54 am

Thanx Dear for ur ans.

Thanks
SUrya

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 6

@@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,My blog: www.igormicev.com

manik_anu SSCrazy Points: 2377 More actions · Answer 7

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.

Junior Galvão - MVP SSCertifiable Points: 6930 More actions · Answer 8

Hi,

I executed this code in SQL Serve 2012 and I received the errors sequence:

(1 row(s) affected)

Msg 50000, Level 16, State 1, Line 2

oh no, error!

(1 row(s) affected)

Msg 50000, Level 16, State 1, Line 6

oh no, another error!

(1 row(s) affected)

I answered 50.000