transaction test!

Question

Post reply

transaction test!

Viewing 4 posts - 16 through 18 (of 18 total)

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

reachjerome Grasshopper Points: 18 More actions · Answer 1

good question. Just-in-time I remembered, table variables do not participate in transactions.

sgivoni SSC-Addicted Points: 491 More actions · Answer 2

Very good question

If you change the line:

DECLARE #test TABLE (id int, pname varchar(100))

to

create table #test (id int, pname varchar(100))

it will return zero rows - which was what I thought it would do - 🙁

Steve Jones - SSC Editor SSC Guru Points: 735195 More actions · Answer 3

I think this is great behavior. Allows you to easily log things that might happen in a transaction that needs to roll back. If you used a permanent table, your logging would be lost.

Ralf Dietrich SSChasing Mays Points: 660 More actions · Answer 4

Hi Steve,

that (logging) I was doing a lot in the past project - and I was missing the point too :crazy:

Every time I tell this fact to customers (e.g. the ones, who was calling me with nearly empty log tables) I know that but was failing.

The best question for a long time. Clear focus, seems easy, but have to read VERY vcarefully.