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: Friday, July 18, 2014 12:06 AM
Points: 146, Visits: 455
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: Today @ 6:52 AM
Points: 5,567, Visits: 24,753
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 1, 2010 8:57 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, July 10, 2014 12:49 PM
Points: 1,676, Visits: 1,754
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 1, 2010 11:04 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Nice question, thanks!
Post #961990
Posted Sunday, August 1, 2010 11:13 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:51 AM
Points: 1,971, Visits: 369
a very good question... thanks
Post #961992
Posted Sunday, August 1, 2010 11:55 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:22 AM
Points: 271, Visits: 96
nice!! but tough to concentrate........
Post #961997
Posted Monday, August 2, 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 2, 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: Monday, May 5, 2014 1:57 PM
Points: 545, Visits: 643
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 2, 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 3, 2010 2:09 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 7:53 AM
Points: 365, Visits: 921
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