返回列表 發帖

語法

insert into bdm2vip '
(id_vip, nm_cust, id_area, id_dept, id_place, nn_tel, nn_mobil, add_email, add_r '
, update_date, dt_ado, cd_kind, yn_use) '
select no_cust, nm_cust, ''KC'', ''01'', ''KC00001'', nn_tel, nn_mobil, add_email, add_r
, update_date, update_date, ''02'', ''Y'' '
from db_tkt.dbo.bdm2cust '
where no_cust not in (select id_vip from bdm2vip) ';

返回列表 回復 發帖