代码改变世界

随笔分类 -  sql数据库技术

SQLServer 2008跨数据库实例事务处理【转】

2011-08-30 15:26 by gzivan, 324 阅读, 收藏,
摘要: CREATE PROCEDURE deleteAccountAll @id int AS SET XACT_abort ON BEGIN DISTRIBUTED TRAN delete from AccountCapital where accountid = @id delete from logininfo where username = @id delete from CapitalRecord where accountid = @id delete from [Trade]..[order] where accountid = @id delete from account wh. 阅读全文