meine Sys/Db admin & Developper Notitzen - wer Rechtschreibfehler findet darf sie behalten ...
my Sys/Db Admin and developper notes - I don't care about typos
Thursday, April 19, 2018
simple sql server merge for insert or update for single row
merge targetTableName as target using (values (@Key)) as source (keyname) on [Key]=source.keyname when matched then update set bla=@bla when not matched then insert ([key], bla) values (@key, @bla)
No comments:
Post a Comment