|
 |
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?
|
|
|
View Cart
