描述:
设置回滚点。
语法:
db.savepoint(spn)
备注:
设置名为spn的回滚点,回滚点名称不能省略也不能重复。
参数:
返回值:
Boolean值
示例:
|
A
|
|
1
|
=connect("demo")
|
|
2
|
=A1.savepoint("num1")
|
设置名字为"num1"的回滚点。
|
3
|
=A1.execute@k("delete
from DEPARTMENT where DEPT='TecSupport'")
|
执行sql,完成不提交事务。
|
4
|
=A1.rollback("num1")
|
回滚到"num1"。
|