ukerandi
asked on
Sql Transaction
Hi
UPDATE rsSalesRecords
SET SalesReansactionDate=NULL
Where SalesPersonID='CCR15200'
COMMIT TRANSACTION;
I need to know if i used Commit Transaction,What will happen
What is the best way to execute above sql with or with out COMMIT TRANSACTION;
UPDATE rsSalesRecords
SET SalesReansactionDate=NULL
Where SalesPersonID='CCR15200'
COMMIT TRANSACTION;
I need to know if i used Commit Transaction,What will happen
What is the best way to execute above sql with or with out COMMIT TRANSACTION;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
this will unlock the filed if not started with Begin Transaction.
Begin Transaction --- or Begin tran
UPDATE rsSalesRecords
SET SalesReansactionDate=NULL
Where SalesPersonID='CCR15200' ************* "Lock acquired"
COMMIT TRANSACTION; -- or Commit - or Commit Tran *********** " lock released"
========================== ========== ========== ========== ========== ========== ========== ==
UPDATE rsSalesRecords
SET SalesReansactionDate=NULL
Where SalesPersonID='CCR15200' ************* "Lock acquired and automatically released by SQL server"
No need to COMMIT here.
UPDATE rsSalesRecords
SET SalesReansactionDate=NULL
Where SalesPersonID='CCR15200' ************* "Lock acquired"
COMMIT TRANSACTION; -- or Commit - or Commit Tran *********** " lock released"
==========================
UPDATE rsSalesRecords
SET SalesReansactionDate=NULL
Where SalesPersonID='CCR15200' ************* "Lock acquired and automatically released by SQL server"
No need to COMMIT here.
ASKER