1)Dirty Read(脏读)
设置为Dirty Read隔离级别的参考语句如下:
SET ISOLATION TO DIRTY READ;
2)Commited Read(只读已提交的数据)
设置为该级别的参考语句如下:
SET ISOLATION TO COMMITTED READ;
3)Cursor Stability(游标稳定性)
参考设置语句如下:
SET ISOLATION TO CURSOR STABILITY;
4)Repeatable Read(可重复读)
参考设置语句如下:
SET ISOLATION TO REPEATABLE READ;
5)Last Committed Read(读取最后提交的数据)
设置语句参考如下:
SET ISOLATION TO COMMITTED READ LAST COMMITTED;