Secure Way Of Executing The Update Statement In Sql Server
EX- BEGIN TRANSACTION UPDATE Employee SET Fname = ‘XYZ’ WHERE ID = 1024; SELECT * FROM Employee WHERE ID = 1024; ROLLBACK TRANSACTION But think while updating the table somebody forgot to use the transaction and updated the table by an UPDATEstatement without using the TRANSACTION statements shown in the above example. This may creats a…
read more