跨库连接视图

最新推荐文章于 2023-06-07 15:43:20 发布

yishanhai

最新推荐文章于 2023-06-07 15:43:20 发布

阅读量971

点赞数

文章标签： user 物流存储工作

本文链接：https://blog.csdn.net/yishanhai/article/details/3290821

版权

跨库连接视图

1. CREATE VIEW dbo.matcode_sfpdm_all

所有的物料包括禁用和未整理的和未审核的不要出现

SELECT sfcm_code as MATCODE, sfcm_picture as DRAWNO, sfcm_name as MATNAME, sfcm_materialcode as STUCODE,

sfcm_esunit as MATUNIT, sfcm_weight as MATWEIGHT, sfcm_materialname as STUADD,sfcc_id ,sfcm_check

FROM OPENDATASOURCE ('SQLOLEDB',

'Data Source=172.21.10.188;User ID=mmc;Password=yj888128' ).sfpdm.dbo.sf_code_material where correct = 1 and delfromstuff=0 and sfcm_check <> 0

执行跨库的存储过程

CREATE PROCEDURE Pro_Add_Order @entime datetime,@joid varchar(50),@ortime datetime ,@fitime datetime,@begincode int,@endcode int,@remark varchar(100),@jname varchar(100),@bg int AS

增加老物流的定单工作号

2007－2－6

EXECUTE OPENDATASOURCE ('SQLOLEDB', 'Data Source=172.21.26.33;User ID=sa;Password=zxcvbnm0981' ).sf.dbo.PRO_TRANS_JOIDORDER_ADD @entime ,@joid ,@ortime ,@fitime ,@begincode ,@endcode ,@remark ,@jname,@bg

IF @@ERROR <> 0

begin

raiserror('错误q2',11,1)

Return

end