five type of transanctions isolation level in sql server 1>READ UNCOMMITTED 2>READ COMMITTED 3>REPEATABLE READ 4>SERIALIZABLE 5>SNAPSHOT