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 «««12345

Cursors Expand / Collapse
Author
Message
Posted Thursday, June 19, 2008 4:46 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 2,953, Visits: 439
I too voiced my protest against "sp_describe_cursor_columns" answer being incorrect.

And I don't think the author reads this thread. Just like the other author (whether he/she is the same or not) reads on the TEXT column update question thread.

I don't think there's any point continuing the thread, we've lost our points and there's no way getting them back



Urbis, an urban transformation company
Post #520282
Posted Friday, June 20, 2008 12:44 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:42 PM
Points: 33,278, Visits: 15,447
Everyone is right, not sure how sp_describe_cursor_columns got chosen as an answer. Must have been a bad day

Busy this week, so I've missed this thread until now. The QOD threads get moved around for some reason, so I don't always see them.

Points awarded back and the question corrected for 3 answers.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #520980
Posted Friday, June 20, 2008 2:58 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:40 PM
Points: 612, Visits: 212
Thanks for awarding....Steve:)
Post #521067
Posted Friday, June 20, 2008 5:10 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:20 PM
Points: 1,276, Visits: 1,134
Thanks Steve, appreciate it. I thought I was missing something obvious on this question :)
Post #521117
Posted Sunday, June 22, 2008 9:19 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 2:42 PM
Points: 33,278, Visits: 15,447
Hey, that's me. Missing the obvious, pointing out the obscure. ;)






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #521414
Posted Monday, June 23, 2008 12:15 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:05 AM
Points: 2,842, Visits: 3,875
Thanks Steve! (whoops, here it would have been my 2nd point ;))

Best Regards,
Chris Büttner
Post #521542
Posted Sunday, March 8, 2009 5:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 25, 2012 4:03 AM
Points: 185, Visits: 52
sp_cursor_list, sp_describe_cursor and @@cursor_rows.
are correct answers. as already so many comments are there so no explaination required for the same.
and one more thing If it is said "@@cursor_rows" requires Non-Dynamic cursor. it should be mentioned in question, other wise you can not mark it wrong.
Post #671087
Posted Sunday, March 8, 2009 9:31 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:14 PM
Points: 37,107, Visits: 31,665
Heh... even after the typo was repaired, no one got the correct answer because it wasn't listed. The correct answer should be...

"Who cares? Rewrite the code to be set based." :P


--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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #671115
Posted Wednesday, August 27, 2014 3:56 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 2,935, Visits: 239
Bummer, missed this one.
Post #1608070
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse