MSSQL connects multiple database tutorials and consolidates data onto a single table
*/
Method One
$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 ";
Method Two
$sql 1 = "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 ... ';
Method Three, this does not connect
$sql 2= "CREATE proc Otherconnsql as"
Begin
DECLARE @t_id varchar (varchar), @t_name (50), @t_tel varchar
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
";