When Oracle is used to deal with nested transactions,it supports transaction consistency as well as autonomous transactions,that is,nested transactions can handle their internal affairs without being influenced by external affairs,while SQLServer has no specific way to realize Oracle autonomous transactions.This paper conducts a research and test on the ways of realizing autonomous transactions by SQLServer,and explores whether SQLServer can realize autonomous transactions and its service regulations.%Oracle对嵌套事务处理除了支持事务的一致性外，还支持自治事务，即嵌套事务可以自己处理内部事务不受外部事务的影响。而 SQLServer则没有实现类似 Oracle自治事务的指定方法。本文主要是对 SQLServer 实现自治事务的方法进行研究与测试，探究 SQL Server能否实现自治事务，以及自治事务的使用规则。
展开▼
