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 123»»»

Transaction rowcount Expand / Collapse
Author
Message
Posted Saturday, July 31, 2010 1:22 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 143, Visits: 447
Comments posted to this topic are about the item Transaction rowcount
Post #961794
Posted Saturday, July 31, 2010 3:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:36 PM
Points: 5,470, Visits: 23,487
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
Posted Sunday, August 01, 2010 8:57 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:53 PM
Points: 1,676, Visits: 1,744
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.

Oleg
Post #961971
Posted Sunday, August 01, 2010 11:04 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 8:50 AM
Points: 2,163, Visits: 2,184
Nice question, thanks!
Post #961990
Posted Sunday, August 01, 2010 11:13 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 2:13 AM
Points: 1,865, Visits: 368
a very good question... thanks
Post #961992
Posted Sunday, August 01, 2010 11:55 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 09, 2013 7:57 AM
Points: 267, Visits: 93
nice!! but tough to concentrate........
Post #961997
Posted Monday, August 02, 2010 12:08 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 27, 2012 12:08 PM
Points: 1,073, Visits: 51
good question
Post #961999
Posted Monday, August 02, 2010 1:58 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 12:23 PM
Points: 545, Visits: 641
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
Posted Monday, August 02, 2010 9:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Tuesday, August 03, 2010 2:09 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 359, Visits: 890
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 »

Add to briefcase 123»»»

Permissions Expand / Collapse