【实战】:sqlserver数据实时同步到mysql(二)
sp_delete @orderno
end
go
--存储过程
use suzhou
go
create PROCEDURE sp_delete(
@orderno char(20)
)
AS
BEGIN
SET NOCOUNT ON;
delete openquery(jt, 'select * from sz') where orderno=@orderno
END
go
---delete数据测试
use suzhou
go
delete from sz where orderno='a001'
go