Transaction rowcount

Question

Post reply

Transaction rowcount

Repriser-991084

Old Hand

Points: 396
More actions
July 31, 2010 at 1:22 pm

#223948

Comments posted to this topic are about the item Transaction rowcount

Viewing 15 posts - 1 through 15 (of 23 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

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[/url]
Before posting a performance problem please read[/url]

Oleg Netchaev SSCertifiable Points: 5276 More actions · Answer 2

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

UMG Developer SSChampion Points: 13482 More actions · Answer 3

UMG Developer

SSChampion

Points: 13482

August 1, 2010 at 11:04 pm

#1200846

Nice question, thanks!

ziangij SSCrazy Eights Points: 8066 More actions · Answer 4

ziangij

SSCrazy Eights

Points: 8066

August 1, 2010 at 11:13 pm

#1200848

a very good question... thanks

udayroy15 Ten Centuries Points: 1077 More actions · Answer 5

udayroy15

Ten Centuries

Points: 1077

August 1, 2010 at 11:55 pm

#1200852

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

pankaj upadhyay Ten Centuries Points: 1184 More actions · Answer 6

pankaj upadhyay

Ten Centuries

Points: 1184

August 2, 2010 at 12:08 am

#1200854

good question

Robert Frasca SSCertifiable Points: 6027 More actions · Answer 7

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.

sakthimadan Old Hand Points: 353 More actions · Answer 8

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

Fozzie SSCrazy Points: 2222 More actions · Answer 9

sakthi_madan,

Run in query analyser:

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

sakthimadan Old Hand Points: 353 More actions · Answer 10

Yeah thanks...

Now i got it...

Thanks for your reply..!!!

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 11

Yep. @@rowcount is a cruel mistress. I avoid her like a rash.

Converting oxygen into carbon dioxide, since 1955.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Nice question. Thanks.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

EugeneMoulin SSChasing Mays Points: 639 More actions · Answer 13

Nice question, but, if we run the given script, don't we have an error on this line ?

select @@rowcount-- check this one out

EuG

sakthimadan Old Hand Points: 353 More actions · Answer 14

sakthimadan

Old Hand

Points: 353

August 5, 2010 at 2:58 am

#1202575

No.. i'm not getting any error..

are you??

Transaction rowcount

Cookies on SQLServerCentral