Merge into [tableName] as tUsing(select [@id] as tid) as t1 on t1.tid=t.idwhen matched then update set name=‘name1‘when not matched then insert(name) values(‘name‘);