先在sqlserver里面链接sybase数据库,假设名字为:mySybase然后在sqlserver里面加一个触发器了
create trigger on Sqltable for inserted
declare @num int
declare @ask_id
select @num=num from inserted
select @ask_id from mySybase..sqltable where num=@num
update sqltable set ask_id=@ask_id where num=@num
create trigger on Sqltable for inserted
declare @num int
declare @ask_id
select @num=num from inserted
select @ask_id from mySybase..sqltable where num=@num
update sqltable set ask_id=@ask_id where num=@num
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货