How to Preview or Rollback Your Database Changes Using Transactions on SQL Server!
How to preview or rollback your database changes using transactions on SQL Server!
Script used in video:
BEGIN TRAN
INSERT INTO NewTable (Name, Age)
VALUES
('Alice', 25),
('Bob', 35);
DELETE FROM NewTable WHERE ID = 1;
UPDATE NewTable SET Age = 40 WHERE Name = 'Alice';
ROLLBACK TRAN
Drop a like if you found this video helpful!