USE Study
GO

SELECT * INTO DEPT01 FROM DEPARTMENT

SELECT * FROM DEPT01

GO
BEGIN TRAN

DELETE DEPT01
SELECT * FROM DEPT01
ROLLBACK TRAN
SELECT * FROM DEPT01