set chained off?

set chained off
有没有ed我忘了,这个命令是什么意思,完成什么功能?
谢了
---------------------------------------------------------------

举个例子
In chained transaction mode, Adaptive Server implicitly executes a begin
transaction statement just before the following data retrieval or
modification statements: delete, insert, open, fetch, select, and update. For
example, the following group of statements produce different results,
depending on which mode you use:
insert into publishers
values ("9906", null, null, null)
begin transaction
delete from publishers where pub_id = "9906"
rollback transaction
In unchained transaction mode, the rollback affects only the delete
statement, so publishers still contains the inserted row. In chained mode,
the insert statement implicitly begins a transaction, and the rollback affects
all statements up to the beginning of that transaction, including the insert.

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus