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
;