mssql 连接多个数据库并把数据整合到一张表上

mssql 连接多个数据库教程并把数据整合到一张表上
*/
//方法一

$sql ="create proc OtherConnSQL
as
begin
    select id=u_id,name=u_name,tel=u_tel from openrowset('SQLNCLI','Server=(local);Trusted_Connection=yes;','select u_id,u_name,U_password,u_tel from ABC.dbo.USER_TABLE') as t
    union all
    select id=id,name=c_name,tel=c_tel from openrowset('SQLNCLI','Server=(local);Trusted_Connection=yes;','select id,c_name,c_tel from CBA.dbo.CU_TABLE') as A
end";

//方法二

$sql1 ="create proc OtherConnSQL
as
begin
select id=u_id,name=u_name,tel=u_tel from openrowset('SQLNCLI','Server=(local);Trusted_Connection=yes;','select u_id,u_name,U_password,u_tel from ABC……";

//方法三，这种没连合

$sql2="create proc OtherConnSQL as
begin
declare @t_id varchar(50),@t_name varchar(50),@t_tel varchar(50)

select @id=u_id,@name=u_name,@tel=u_tel from openrowset('SQLNCLI','Server=(local);Trusted_Connection=yes;','select u_id,u_name,U_password,u_tel from ABC.dbo.USER_TABLE') as t

select @id=id,@name=c_name,@tel=c_tel from openrowset('SQLNCLI','Server=(local);Trusted_Connection=yes;','select id,c_name,c_tel from CBA.dbo.CU_TABLE') as A 
end

";

补充：数据库,Mssql

上一个：同步两个SQLServer数据库的内容解决方法
下一个：mssql 使用游标遍历方式批量update更新数据