USE tempdb

GO

CREATE TABLE myTest (Id INT,Name VARCHAR(256))

GO

INSERT INTO myTest (Id,Name) VALUES (1,'abc')

INSERT INTO myTest (Id,Name) VALUES (2,'def')

INSERT INTO myTest (Id,Name) VALUES (3,'ert')

INSERT INTO myTest (Id,Name) VALUES (4,'xyz')

GO

SELECT * FROM myTest

BEGIN TRAN

TRUNCATE TABLE myTest

ROLLBACK TRAN

SELECT * FROM myTest

GO

SELECT * FROM myTest

BEGIN TRAN

DELETE FROM myTest

ROLLBACK TRAN

SELECT * FROM myTest

DROP TABLE myTest