RajaSekar's Blog
SharePoint,.Net,SQL,LINQ,Orchard CMS Tips
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment