【IT168 服务器学院】在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
