我重裝我系統後後運這語句就出錯了,以前可能的,兩台機是不同的域中,如何解決?
SELECT DISTINCT a.codeno,a.name FROM dbo.ModelNo full outer JOIN OPENDATASOURCE ('SQLOLEDB','database=pmsweb;server=202.76.37.110;uid=pmsdata;pwd=itdept').pmsweb.dbo.vpmscompany a ON dbo.ModelNo.Code = a.Codeno where a.cid<>'' and modelno.am='bao'出錯代碼:
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
SELECT DISTINCT a.codeno,a.name FROM dbo.ModelNo full outer JOIN OPENDATASOURCE ('SQLOLEDB','database=pmsweb;server=202.76.37.110;uid=pmsdata;pwd=itdept').pmsweb.dbo.vpmscompany a ON dbo.ModelNo.Code = a.Codeno where a.cid<>'' and modelno.am='bao'出錯代碼:
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货