我一个极度简单的问题，问题虽然简单，但又极别重要。所以放高分!

[ZXYSOSO]

Update P
Set P.fldComPanys=T.fldComPanys,
P.fldDeliveryPlaceS=T.fldDeliveryPlaceS,
P.fldWarehouseS=T.fldWarehouseS
From svr_Master_Po P, #Tmp_Po T
Where P.fldPoNos=T.fldPoNos
And P.fldVendorCodes=T.fldVendorCodes

Select @PayMent=isnull(fldpaymentdays,'')+isnull(fldpaymentterms,'')+isnull(fldpaymentchannels,'')+isnull(fldpaymentremarks,'')
From svr_Master_Vendor
Where fldVendorCodeS=@Vendor

Update P
Set P.fldComPanys=T.fldComPanys,
P.fldDeliveryPlaceS=T.fldDeliveryPlaceS,
P.fldWarehouseS=T.fldWarehouseS
From svr_PR_POQty P, #Tmp_Po T
Where P.fldPoNos=T.fldPoNos

假如要更新上面两个表，那事务应该怎样加呢？

如果这样可以吗？
SET XACT_ABORT ON
Begin Tran
......
......
Commit Tran
这样做，会不会锁住表？

如果要用Rollback Tran,应该怎样用呢？

[WangZWang]

如：
Begin Tran
Update P
Set P.fldComPanys=T.fldComPanys,
P.fldDeliveryPlaceS=T.fldDeliveryPlaceS,
P.fldWarehouseS=T.fldWarehouseS
From svr_Master_Po P, #Tmp_Po T
Where P.fldPoNos=T.fldPoNos
And P.fldVendorCodes=T.fldVendorCodes
if @@error<>0 goto error

Select @PayMent=isnull(fldpaymentdays,'')+isnull(fldpaymentterms,'')+
isnull(fldpaymentchannels,'')+isnull(fldpaymentremarks,'')
From svr_Master_Vendor
Where fldVendorCodeS=@Vendor

Update P
Set P.fldComPanys=T.fldComPanys,
P.fldDeliveryPlaceS=T.fldDeliveryPlaceS,
P.fldWarehouseS=T.fldWarehouseS
From svr_PR_POQty P, #Tmp_Po T
Where P.fldPoNos=T.fldPoNos
if @@error<>0 goto error

Commit Tran
Return

error:
Rollback Tran
Print 'Error!'
go

[wwh999]

顶楼上的贴...真是快，不写了.

[ZXYSOSO]

这样做可不可以？会锁表吗？
SET XACT_ABORT ON
Begin Tran
......
......
Commit Tran

[WangZWang]

如果只有这条语句执行，不会锁表，
SET XACT_ABORT ON　打开后，遇到错误
会自动进行回滚Rollback Tran.

[zjcxc]

SET XACT_ABORT ON
Begin Tran
......
......
Commit Tran
这样做，会不会锁住表？

如果要用Rollback Tran,应该怎样用呢？

------------------------------------------

rollback tran在出错时自动进行. 至于锁表, 事务中的update在事务提交或者回滚前肯定是要锁表的

[yjlhch]

学习

[xyxfly]

：）

[cywarson]

试一试..