If I don't set the isolation level in transaction. Then what isolation level is set.

See more:

SQL-Server

As I know that, READ COMMITTED is the default isolation level. But if I don't set isolation level within transaction. in that case, what would be the isolation level. Is it READ COMMITTED or anything else.

What I have tried:

BEGIN TRANSACTION MyTransaction
BEGIN TRY
UPDATE Account SET Debit=100 WHERE Name='John Cena'
UPDATE ContactInformation SET Mobile='1234567890' WHERE Name='The Rock'
COMMIT TRANSACTION MyTransaction
PRINT 'TRANSACTION SUCCESS'
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION MyTransaction
PRINT 'TRANSACTION FAILED'
END CATCH