Return

Question

Return

Umer Akram

SSC-Insane

Points: 22209
More actions
August 17, 2013 at 4:13 pm

#277050

Comments posted to this topic are about the item Return

Viewing 15 posts - 1 through 15 (of 27 total)

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

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Nice one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

Koen Verbeeck (8/18/2013)
Nice one, thanks.

+1

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

Easy one at start of the week 🙂

Thanks

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Lokesh Vij SSChampion Points: 10836 More actions · Answer 4

kapil_kk (8/18/2013)
Easy one at start of the week 🙂
Thanks

+1 🙂

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

sqlnaive SSCoach Points: 17437 More actions · Answer 5

Ohh Gosh... Caught in the trap. Not a good start for the week. :sick:

It was just another "be on your toes" QOTD. 🙂

sqlnaive SSCoach Points: 17437 More actions · Answer 6

Ohh Gosh... Caught in the trap. :sick: Not a good start to the week for me.

It was one of those "on your toes" QOTD. 🙂

Richard Warr SSCertifiable Points: 6967 More actions · Answer 7

I knew the RETURN would kick in with a value of 1 so decided that that was one row returned :crazy:

Rune Bivrin SSCrazy Eights Points: 8525 More actions · Answer 8

Got it. But to be precise there won't even be a result set. Not even one with zero rows.

Just because you're right doesn't mean everybody else is wrong.

Nick Doyle SSC Eights! Points: 926 More actions · Answer 9

Nick Doyle

SSC Eights!

Points: 926

August 19, 2013 at 6:24 am

#1642638

Thanks, easy question 🙂

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 10

PRAMANA.DBA

SSCertifiable

Points: 5507

August 19, 2013 at 6:36 am

#1642646

+1 😎

aochss SSCommitted Points: 1677 More actions · Answer 11

Good QotD...As usual, it seems the best way to learn new items is to take a little quiz on them. I learned a couple of new things today..just not related to the point of the question.

First, I thought it was going to throw a syntax error on this statement, but it is valid. I guess it will once you add a new column to the table, it will give you some grief.

INSERT INTO @TABLE

SELECT @a

Second, I have used compound operators in C#, but not in SQL.

http://msdn.microsoft.com/en-us/library/cc645922.aspx

Anton

Nilima Mehtre Grasshopper Points: 22 More actions · Answer 12

Nilima Mehtre

Grasshopper

Points: 22

August 19, 2013 at 7:18 am

#1642674

I am not getting why the answer is zero rows

Nick Doyle SSC Eights! Points: 926 More actions · Answer 13

M07 (8/19/2013)
I am not getting why the answer is zero rows

The select from the table variable is at the end of the procedure, but the procedure is exited at the return statement. The select is never executed. Hope this helps.

Nilima Mehtre Grasshopper Points: 22 More actions · Answer 14

Nilima Mehtre

Grasshopper

Points: 22

August 19, 2013 at 7:28 am

#1642682

thanks its helpful