(A)同一服務器上連接不同的數據庫
DBF.dbo.Table_NAME
DBF 數據庫名
dbo 是必須寫的
Table_NAME 連接的表名
例 1:
select a.k_teacherid ,a.b_cystatus,b.k_name,c.school_name
from b_shouinform a,k_teacher b,charge_kindergarten.dbo.DIC_SCHOOL_NAME c
where c.school_code=b.k_schoolid and a.k_teacherid=b.k_teacherid and b_iid='62'
例 2:
select * from charge_kindergarten.dbo.DIC_SCHOOL_NAME a,kinder.dbo.k_teacher b
where a.school_code=b.k_schoolid
(B)不同服務器連接
lssjx 當前服務器上表
select * from lssjx where saveid in
(
select user_id from opendatasource
('SQLOLEDB',
'server=192.168.0.2;uid=sa;pwd=;database=zxx').zxx.dbo.teach
)
//////////////////////////服務器上ip---server=192.168.0.2
///////所要連接的數據庫-------database=zxx
,(zxx.dbo.teach 數據庫中的teach表)
posted on 2008-10-06 10:24
毒毒 閱讀(1113)
評論(0) 編輯 收藏