Tuesday, 2 August 2011

Tempory delete data after rollback datas in sql


HI,
--CREATETABLE

CREATE TABLE TEP(SNO NUMERIC(10),NAME NVARCHAR(50))

INSERT INTO TEP VALUES(4,'RESOURCES')
--BEGINTRANSACTION
BEGIN TRANSACTION TEP
DELETE FROM TEP
--ROLLBACKTRANSACTION
ROLLBACK TRANSACTION TEP

No comments:

Post a Comment