Whenever you change data, in a Data Manipulation Language(DML) command, you can wrap your changes in a transaction. DML includes
DELETE. One of the ways that you can make sure that you're changing the right data would be to use a transaction.
DML changes will take a lock on the rows affected. When you begin a transaction, you must end the transaction or all objects being changed in the DML will remain locked by whoever began the transaction. You can end your transaction with either
ROLLBACK returns everything within the transaction to its original state.
COMMIT places the data into a final state where you cannot undo your changes without another DML statement.
--Create a test table USE [your database] GO CREATE TABLE test_transaction (column_1 varchar(10)) GO INSERT INTO dbo.test_transaction ( column_1 ) VALUES ( 'a' ) BEGIN TRANSACTION --This is the beginning of your transaction UPDATE dbo.test_transaction SET column_1 = 'B' OUTPUT INSERTED.* WHERE column_1 = 'A' ROLLBACK TRANSACTION --Rollback will undo your changes --Alternatively, use COMMIT to save your results SELECT * FROM dbo.test_transaction --View the table after your changes have been run DROP TABLE dbo.test_transaction