在SQL Server 2000的查询分析器中输入以下代码:
Select * From
OPENROWSET('SQLOLEDB', 'mhj'; 'sa'; '', 'Select * From online.Dbo.A11Czzk1') As b
Where (b.SurveyPointNo Not In (Select SurveyPointNo From online.Dbo.A11Czzk1)) or
(b.SurveyTime Not In (Select SurveyTime From online.Dbo.A11Czzk1))
运行没有任何问题,然而运行以下语句:
Insert Into A11Czzk1
Select * From
OPENROWSET('SQLOLEDB', 'mhj'; 'sa'; '', 'Select * From online.Dbo.A11Czzk1') As b
Where (b.SurveyPointNo Not In (Select SurveyPointNo From online.Dbo.A11Czzk1)) or
(b.SurveyTime Not In (Select SurveyTime From online.Dbo.A11Czzk1))
便显示:服务器: 消息 8501,级别 16,状态 3,行 1
服务器 'SERVER' 上的 MSDTC 不可用。
如何解决此类问题呢??错在哪儿呢??
Select * From
OPENROWSET('SQLOLEDB', 'mhj'; 'sa'; '', 'Select * From online.Dbo.A11Czzk1') As b
Where (b.SurveyPointNo Not In (Select SurveyPointNo From online.Dbo.A11Czzk1)) or
(b.SurveyTime Not In (Select SurveyTime From online.Dbo.A11Czzk1))
运行没有任何问题,然而运行以下语句:
Insert Into A11Czzk1
Select * From
OPENROWSET('SQLOLEDB', 'mhj'; 'sa'; '', 'Select * From online.Dbo.A11Czzk1') As b
Where (b.SurveyPointNo Not In (Select SurveyPointNo From online.Dbo.A11Czzk1)) or
(b.SurveyTime Not In (Select SurveyTime From online.Dbo.A11Czzk1))
便显示:服务器: 消息 8501,级别 16,状态 3,行 1
服务器 'SERVER' 上的 MSDTC 不可用。
如何解决此类问题呢??错在哪儿呢??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货