編碼不同時的資料關聯

	select ima01,ima02,ima021,ima04,ima06,ima08,ima15,ima43,ima48,ima49,ima67,ima76  
	from openquery(KSTiptop
	,'select ima01,ima02,ima021,ima04,ima06,ima08,ima15,ima43,ima48,ima49,ima67,ima76 
	from ima_file') a 
	where a.ima01 COLLATE Chinese_PRC_CI_AS  not in(select ima01 from mrp.ima_file);

	update mrp.ima_file set ima02=b.ima02,ima021=b.ima021
           ,ima04=b.ima04,ima06=b.ima06,ima08=b.ima08
           ,ima15=b.ima15,ima43=b.ima43,ima48=b.ima48
           ,ima49=b.ima49,ima67=b.ima67,ima76=b.ima76
	     from mrp.ima_file a,openquery(KSTiptop
	,'select ima01,ima02,ima021,ima04,ima06,ima08,ima15,ima43,ima48,ima49,ima67,ima76 
	from ima_file') b where a.ima01 COLLATE Chinese_PRC_CI_AS=b.ima01;