22,210
社区成员
发帖
与我相关
我的任务
分享
exec sp_configure 'show advanced options',1
go
reconfigure
go
exec sp_configure 'Ad Hoc Distributed Queries',1
go
reconfigure
go
use MonitorProject
go
insert Into OpenDataSource
('SQLOLEDB',
'Data Source=HHH-PC\SQLEXPRESS;
Initial Catalog=MonitorProject;
Integrated Security=True;
Persist Security Info=False').MonitorProject.dbo.ProjectInfo
select * From ProjectInfo where [ProjectName] ='Test'
Insert Into OPENDATASOURCE(
'SQLOLEDB',
'Data Source=HHH-PC\SQLEXPRESS;User ID=sa;Password=123'
).MonitorProject.dbo.ProjectInfo
Select * From ProjectInfo where [ProjectName] ='Test'
select * from OpenDataSource
('SQLOLEDB.1',
'Data Source=HHH-PC\SQLEXPRESS;
Initial Catalog=MonitorProject;
Integrated Security=True;
Persist Security Info=False').MonitorProject.dbo.ProjectInfo