SQL-連線方式備忘

1.WebConfig- 2組對不同 機器

Fast_Query-公用a

Fast_Query2-公用b

2.AddLinkServer-OpenQuery

ADO 自已手動寫

SQL-跨機器 OPENQUERY

AddLinkServer 開

INSERT OPENQUERY (trovta, 'SELECT ac_proj,ac_proja,pr_dp_no,ma_dp_no FROM ICDB1.iemis.iepb17h')

select cmsc_proj,left(proj_name,40),pr_dp_no,ma_dp_no from ixERP003_1 where

cmsc_proj not in (select * FROM openquery(trovta, 'SELECT ac_proj FROM ICDB1.iemis.iepb17h '));

AddLinkServer 關

SQL-AddLinkserver

select * from sys.servers (查看目前多少可連線server)

--建server

exec sp_addlinkedserver 'Trovta', '', 'SQLOLEDB','IP' ;

exec sp_addlinkedsrvlogin 'Trovta', 'false',null, 'account', 'pass';

go

select * FROM openquery(Trovta, 'SELECT * FROM DBName.sys.TableName') ;

--刪server

Exec sp_droplinkedsrvlogin 'Trovta',Null ;

Exec sp_dropserver 'Trovta';

IIS 7.5-備忘

一些基本設定要去應用集區設置

EX FreamkWork 版本