The query should be:

insert into Recv_info_Tmp(prod_section_c, sub_section_c, slip_no, Order_no, product_no, cusdesch_c1, cusdesch_c2 ) values ('235400', '00', '10003', 'TEST0123451', N'ZZZZKZ999999999999', '9993', '93')

Note the N prefix before the unicode string (N'ZZZZKZ999999999999')

Regards,

Andras