2,596
社区成员
发帖
与我相关
我的任务
分享
select * into #SQLJITMater
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=10.8.4.168;UID=sa;PWD=sa',
'select * from JIT_DB.dbo.T_JITMaterial')
SELECT a.*
FROM OPENROWSET('MSDASQL',
'DRIVER={SQL Server};SERVER=seattle1;UID=manager;PWD=MyPass',
pubs.dbo.authors) AS a
ORDER BY a.au_lname, a.au_fname