CREATE TABLE #temp (
tt nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS,
aa nvarchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS
)
insert into #temp
select ) name ,[classtype_work] from (
SELECT
name = cast(name COLLATE SQL_Latin1_General_CP1_CI_AS as nvarchar(15))
,[classtype_work]=cast(classtype_work COLLATE SQL_Latin1_General_CP1_CI_AS as nvarchar(20))
FROM OPENDATASOURCE('SQLOLEDB','Data Source=192.168.1.205,1433;User ID=sa;Password=123456').[wilsonhr].[dbo].[kq_datereport]
)a
select * from #temp
drop table #temp
插入临时表时,出现乱码 而在查询时,正常
------解决方案--------------------