在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
关闭本页
|