Roll Back Transactions

/*ROLL BACK TRANSACTIONS*/

GO

--CREATE TABLE AND INSERT SINGLE ROW

CREATE TABLE #TEMPTABLE (COL1 VARCHAR(100))

INSERT INTO #TEMPTABLE (COL1)

VALUES ('TEMP DATA - 01')

SELECT * FROM #TEMPTABLE;

--SELECT ONE TABLE

SELECT * FROM PERSONS;

/*

INSERT ADDITIONAL ROW IN TRANS

ROLLBACK TRANSACTION AT THE END

*/

BEGIN TRAN

--INSERT SINGLE ROW

INSERT INTO #TEMPTABLE (COL1)

VALUES ('TEMP DATA - 02')

--INSERT SINGLE ROW

INSERT INTO PERSONS (P_ID,LASTNAME,FIRSTNAME,ADDRESS,CITY)

VALUES (6,'KUMAR','RAM','NORTH GATE','MADURAI')

--CHECK THE VALUES IN TABLE AFTER TRANSACTION

SELECT * FROM #TEMPTABLE;

SELECT * FROM PERSONS;

ROLLBACK

--CHECK THE VALUES IN TABLE AFTER ROLLBACK THE TRANSACTION

SELECT * FROM #TEMPTABLE

SELECT * FROM PERSONS;

GO

--CLEAN UP

DROP TABLE #TEMPTABLE

GO