sqlserver 把一个表中的几列数据插入到另外一个表

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)