Transaction rowcount

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Jason S Wong » Transaction rowcount

24 posts, Page 1 of 3

1 2 3 »»»

Transaction rowcount

Rate Topic

Display Mode

Topic Options

Author

Message

Repriser-991084

Posted Saturday, July 31, 2010 1:22 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:54 AM
Points: 142, Visits: 414

Comments posted to this topic are about the item Transaction rowcount

Post #961794

bitbucket-25253

Posted Saturday, July 31, 2010 3:15 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 5,101, Visits: 20,200

Nice question

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

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #961808

Oleg Netchaev

Posted Sunday, August 01, 2010 8:57 PM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:39 PM
Points: 1,662, Visits: 1,708

Nice question, I liked that it is clean and straightforward, no tricks. The column names in that table of yours are not very nice though. BigGrin

Oleg

Post #961971

UMG Developer

Posted Sunday, August 01, 2010 11:04 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Nice question, thanks!

Post #961990

ziangij

Posted Sunday, August 01, 2010 11:13 PM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,527, Visits: 359

a very good question... thanks Smile

Post #961992

udayroy15

Posted Sunday, August 01, 2010 11:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, February 02, 2013 5:42 AM
Points: 190, Visits: 74

nice!! but tough to concentrate........

Post #961997

pankaj upadhyay

Posted Monday, August 02, 2010 12:08 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, March 27, 2012 12:08 PM
Points: 1,073, Visits: 51

good question

Post #961999

Robert Frasca

Posted Monday, August 02, 2010 1:58 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:28 AM
Points: 534, Visits: 594

Nice question. You got me with the last SELECT setting the value to 1. I thought it returned 0.

"Beliefs" get in the way of learning.

Post #962440

sakthimadan

Posted Monday, August 02, 2010 9:29 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 30, 2012 1:50 AM
Points: 143, Visits: 79

Can anyone explain me, how does it return '1' as the last rowcount???

Post #962568

Fozzie

Posted Tuesday, August 03, 2010 2:09 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:54 AM
Points: 356, Visits: 753

sakthi_madan,

Run in query analyser:

SELECT @@ROWCOUNT
SELECT @@ROWCOUNT

The first statement returns a row with 0
The second statement is the count of rows returned from the first, i.e 1 row of 0.

Hope that makes sense.

I got the answer wrong as well... so close yet so far. Good question.

Kev

Post #962636

« Prev Topic | Next Topic »

24 posts, Page 1 of 3

1 2 3 »»»

Permissions