merge into [dbo].[Rx_Sys_调度账户表] as a
using [dbo].[Tab_司机] as b --as b 这里的[dbo].[T_Class_A]也可以是子查询
on a.[用户编号]=b.[编号]
when matched
then update set
a.[创建时间]=b.[创建时间]
when not matched
then insert(
[用户编号],
[用户账号],
[密码],
[用户姓名],
[所属网点],
[启用],
[创建时间],
[编辑时间],
[手机号码],
[Token码],
[手机内码],
[消息编码],
[app密码],
[备注],
[用户类型],
[部门编号],
[已实名]
)
values
(
b.[编号],
b.[手机号],
b.[登录密码],
(CASE WHEN b.[姓名] IS NULL THEN ‘NO VALUE’ ELSE b.[姓名] END),
(CASE WHEN b.[所属网点] IS NULL THEN ‘NO VALUE’ ELSE b.[所属网点] END),
‘1’,
b.[创建时间],
b.[修改时间],
b.[手机号],
b.[Token码],
b.[手机内码],
b.[消息编码],
‘’,
b.[备注],
‘0’,
‘6001’,
‘’
);
sqlserver merge
最新推荐文章于 2024-02-19 16:53:07 发布