1、 在sqlserer中 创建 所要搭建的服务
2.、在sql查询中 如下案例 创建 视图 数据
create
view V_CP
as
select t.inp_no,t.diag_name,t.dept_id,t3.out_date,t4.exec_date from OPENQUERY(tpemr, 'select * from emr_cp_exec_master') as t
inner join ( select min(t2.exec_date) as exec_date,t2.exmaster_id from OPENQUERY(tpemr, 'select * from emr_cp_exec_master_ex') as t2 group by t2.exmaster_id) t4 on t.exmaster_id = t4.exmaster_id
left join OPENQUERY(tpemr, 'select * from emr_cp_exec_out') as t3 on t.exmaster_id = t3.exmaster_id
as
select t.inp_no,t.diag_name,t.dept_id,t3.out_date,t4.exec_date from OPENQUERY(tpemr, 'select * from emr_cp_exec_master') as t
inner join ( select min(t2.exec_date) as exec_date,t2.exmaster_id from OPENQUERY(tpemr, 'select * from emr_cp_exec_master_ex') as t2 group by t2.exmaster_id) t4 on t.exmaster_id = t4.exmaster_id
left join OPENQUERY(tpemr, 'select * from emr_cp_exec_out') as t3 on t.exmaster_id = t3.exmaster_id
上面东西写的很粗糙 。