How Many Rows Remain?

Question

Post reply

How Many Rows Remain?

Steve Jones - SSC Editor

SSC Guru

Points: 736173
More actions
September 21, 2020 at 12:00 am

#3782560

Comments posted to this topic are about the item How Many Rows Remain?

Viewing 5 posts - 1 through 4 (of 4 total)

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

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 1

Nice reminder

Thanks Steve

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 2

Steve Jones - SSC Editor

SSC Guru

Points: 736173

September 21, 2020 at 2:54 pm

#3789816

Thanks, glad you liked it

BTylerWhite SSCommitted Points: 1569 More actions · Answer 3

Thanks for the added documentation on this!

https://github.com/MicrosoftDocs/sql-docs/commits/live/docs/t-sql/language-elements/variables-transact-sql.md

It's important to note, this behavior is similar with normal variables as well.

DECLARE @Amount int = 0;

BEGIN TRANSACTION;

SET @Amount = 100;

ROLLBACK TRANSACTION;

SELECT @Amount;

Sue_H SSC Guru Points: 90860 More actions · Answer 4

BTylerWhite wrote:

Thanks for the added documentation on this!
https://github.com/MicrosoftDocs/sql-docs/commits/live/docs/t-sql/language-elements/variables-transact-sql.md
It's important to note, this behavior is similar with normal variables as well.
DECLARE @Amount int = 0;

BEGIN TRANSACTION;

SET @Amount = 100;

ROLLBACK TRANSACTION;

SELECT @Amount;

That was a QOTD a couple of weeks ago...using local variables. Steve's testing to see who is paying attention 🙂

Sue