transaction test!

• reachjerome

  Grasshopper

  Points: 18

  More actions

  July 13, 2009 at 1:56 pm

  #1024130

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

• sgivoni

  SSC-Addicted

  Points: 491

  More actions

  July 29, 2009 at 5:25 am

  #1031547

  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: 737757

  More actions

  July 29, 2009 at 8:18 am

  #1031718

  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

  Say Hey Kid

  Points: 671

  More actions

  August 20, 2009 at 5:12 pm

  #1042517

  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.