Does SQL Server 2005 Express support rollbacks? For example:
BEGIN;
UPDATE Customer
SET LastName = 'Jones';
ROLLBACK;
The ROLLBACK will undo/reverse the changes made by the UPDATE befor a COMMIT is executed.
Yeah, SQL server 2005 express supports transactions, I have used them on some of my projects.
Maybe your code should begin with
BEGIN TRANSACTION
|||Thanks. I'll give that a try. I'm moving from the PostgreSQL sql syntax to MS SQL Server sql syntax. In PostgreSQL, I can give the command:
BEGIN;
...
COMMIT;
to complete the transaction. I guess in MS SQL Server the syntax needs to include 'BEGIN TRANSACTION'. Thanks again for the help.
A good practice is to use Try..CATCH statements with transactions. Check here
http://technet.microsoft.com/en-us/library/ms175976.aspx
|||Thanks for the TRY CATCH suggestion!
