问linux系统选什么版本都一样吗？

merge tablename with(HOLDLOCK) as target

using (values ('new value', 'different value'))

    as source (field1, field2)

    on target.idfield = 7

when matched then

    update

    set field1 = source.field1,

        field2 = source.field2,

        ...

when not matched then

    insert ( idfield, field1, field2, ... )

    values ( 7,  source.field1, source.field2, ... )

begin tran

if exists (select * from table with (updlock,serializable) where key = @key)

begin

   update table set ...

   where key = @key

end

else

begin

   insert into table (key, ...)

   values (@key, ...)

end

commit tran

begin tran

   update table with (serializable) set ...

   where key = @key

   if @@rowcount = 0

   begin

      insert into table (key, ...) values (@key,..)

   end

commit tran