sqlserver 把一个表中的几列数据插入到另外一个表当中。
当被插入表拥有唯一键约束,或者插入的某列数据不能有重复值的时候,用where not exists(select 1 from rf_user b where a.phone = b.u_account)判断原来表是不是已存在。
insert into rf_user(u_account,u_name,u_branch,u_add_time,u_status,u_icId)
select phone,name,'1' as u_branch,GETDATE() as u_branch,'1' as u_status,
'1' as u_icId from teacher a
where not exists(select 1 from rf_user b where a.phone = b.u_account)