使用OPENROWSET方式时如何写连接字符串属性？急....

Question

Integrated Security=SSPI;insert into dsguest select a.* 
from OPENROWSET
('sqloledb','server=ch;Integrated Security=SSPI;uid=sa;pwd=1','SELECT USID,USNAME,USSEX,USCITY,USFPTYPE,USMOB,USTEL,USED,USV0CATION,USPROFESSION,USPOSSION,USADDRESS,USEMAIL,USFP,A1,A2,A3 FROM idverify_try.dbo.dsguest ORDER BY usid') AS a

Answer 1

Integrated Security=SSPI;insert into dsguest select a.* 
from OPENROWSET
('sqloledb','server=ch;Integrated Security=SSPI','SELECT USID,USNAME,USSEX,USCITY,USFPTYPE,USMOB,USTEL,USED,USV0CATION,USPROFESSION,USPOSSION,USADDRESS,USEMAIL,USFP,A1,A2,A3 FROM idverify_try.dbo.dsguest ORDER BY usid') AS a

Answer 2

--opendatasource可以,openrowset测试不过select * from opendatasource('sqloledb',
'Integrated Security=SSPI;Data Source=zj'
).test.dbo.sysobjects

Answer 3

--楼主的语句可以这样修改insert into dsguest 
select USID,USNAME,USSEX,USCITY,USFPTYPE,USMOB,USTEL,USED,USV0CATION,USPROFESSION,USPOSSION,USADDRESS,USEMAIL,USFP,A1,A2,A3
from opendatasource('sqloledb',
'Integrated Security=SSPI;Data Source=ch'
).idverify_try.dbo.dsguest
ORDER BY usid

Answer 4

下面是openrowset的语法说明，从这里看不出可以支持集成验证
OPENROWSET ( 'provider_name'
    , { 'datasource' ; 'user_id' ; 'password'
        | 'provider_string' }
    , { [ catalog.] [ schema.] object
        | 'query' } 
    )

Answer 5

就是这样的：--opendatasource可以,openrowset测试不过

Answer 6

'Trusted_Connection=yes;Integrated Security=SSPI;Data Source=servername;Initial Catalog=master'