在Sybase ASE中使用Passthrough

必须使用事务
declare @sql1 varchar(255)
select @sql1='update Goods set Name='+''''+'ABCD'+''''+',ShortName='+''''+'ABC'+''''+'where GoodsID=4655'
begin tran
exec sp_passthrough_user '订阅用户ID'
exec sp_passthrough_subscription 'BP_HQ_BDATA'
exec sp_passthrough @sql1
exec sp_passthrough_stop
commit tran