標題: 語法 [打印本頁]

---

作者: pillar62    時間: 2013-9-29 14:49     標題: 語法

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) ';

---

歡迎光臨 阿助的簡易論壇 (http://dc.sino.idv.tw/)

Powered by Discuz! 7.2