select * into #t2 from (
select a.* from (SELECT cast( CHECKSUM(*) as varchar(50)) as [CheckSum],ZYH,BHID,XM,SFZH,XB,SF,XZZ, CONVERT(varchar, dbo.fn_ConvertDateTime(RYRQ), 23) as RYRQ,CONVERT(varchar, dbo.fn_ConvertDateTime(CYRQ), 23)as CYRQ,ZDFLAG,cast(ZZD as varchar(2000)) as ZZD,LCZD,CYQK,SWSJ,SWYY,KSBM,KSMC,ZZYS,ZZYSMC,DATATIME
FROM
OPENROWSET(
'MSOLEDBSQL','Server=10.0.0.11;UID=a;PWD=a1122;','select * from v1 where DATATIME > DATEADD(day,-3, GETDATE()) ' )
--使用MSOLEDBSQL驱动 能支持最新的格式,突破旧驱动最多能取50个字符
) a where a.[CheckSum] not in (select [CheckSum] from tbl1 )
) b