Commit & Roleback

Accepted answer

Yes you can in SQL Server

Please refer this example:

SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO

CREATE TABLE dbo.TestTable(
TestId INT IDENTITY(0, 1) NOT NULL,
TEST1 VARCHAR(255) NOT NULL
)
GO

COMMIT;

Abhineet Srivastava13y ago

Ok..

Thanks

Abhishek Jain13y ago

Well it basically means that any other transaction cannot modify any data that has been read by the current transaction. But you can use any other Isolation level according to your needs...

Abhineet Srivastava13y ago

Thanks Abhishek !!

Well, What is the meaning of this line--

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

Ravi Shekhar13y ago

Yeah you can use...
very good example given by subhrosaha sir.
check out

http://subhrosaha.wordpress.com/2010/03/12/rollback-all-ddl-commands-in-sql-server/