查詢未LINK DB中的資料
OPENDATASOURCE ('SQLOLEDB','Data Source=ServerName;User ID=ID;Password=PW').DB.dbo.table
EX:
SELECT     TOP (100) PERCENT dbo.t_Prod_Info.PcbSerialNo, dbo.t_VIP_Prod_Info.SerialNo
FROM         OPENDATASOURCE ('SQLOLEDB','Data Source=DB2;User ID=ID;Password=PW').DBNAME.dbo.Order_Info INNER JOIN
                      dbo.t_Prod_Info ON OPENDATASOURCE ('SQLOLEDB','Data Source=DB2;User ID=ID;Password=PW').DBNAME.dbo.OID = dbo.t_VIP_Prod_Info.OID
WHERE     (dbo.t_Order_Info.Ordernumber IN ('XXXXXX', 'YYYYYY', 'ZZZZZZ',))