p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

aspdotnet_website_programming thread: Need to Wrap Single SQL Statements in a Transaction?


Message #1 by "Harley Quilliam" <Harley@Q...> on Thu, 27 Feb 2003 16:09:46
On p224 of the VB Version of the book, the authors have put a single SQL 
UPDATE statement inside a transaction.
I thought that a single SQL statement was ATOMIC, so that it didn't need 
to be within a transaction, or am I wrong?
Message #2 by "Mark Hartshorn" <mark.mch1@n...> on Fri, 28 Feb 2003 00:53:09
Your correct that a single sql update statement can be classed as ATOMIC, 
but for good coding practice you would still put any update into a 
transaction.
Message #3 by "Harley Quilliam" <harley@q...> on Fri, 28 Feb 2003 09:47:51
Does it affect performance to have a transaction where it is not strictly 
needed?

  Return to Index