John is a SQL Server developer who is...

Question

John is a SQL Server developer who is...

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
December 28, 2007 at 10:34 am

#62762

Comments posted to this topic are about the item John is a SQL Server developer who is...

Viewing 4 posts - 1 through 3 (of 3 total)

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

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

Heh... I got the answer right but the real answer isn't one of those listed. The question is "What must he worry about when using the @@FETCH_STATUS function in his code?" and if he's using a cursor to use "T-SQL to loop through a set of results in perform an action in a set of cursor", then he should be more concerned about whether I fire him for using RBAR on steroids 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736212

December 28, 2007 at 12:57 pm

#763390

Good thing John doesn't work for Jeff 😉

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Heh... see that! Another good answer that wasn't in the possible answers :hehe:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)