MERGE in SQL Server to insert, update and delete at the same time

preview_player
Показать описание
MERGE in SQL Server to insert, update and delete at the same time

#RDZenTech
Рекомендации по теме
Комментарии
Автор

Thank you kindly! Greetings from Brazil!

sinvalfelisberto
Автор

Nice, hoping for your success.
Thanks a lot. 👍

sorandomm
Автор

EmployeeName should also updated when IDs are matching (maybe it's changed) Or Use the EmployeeName as linking field also (ON source.EmployeeID = target.EmployeeID AND source.EmployeeName = target.EmployeeName)

gergoigaz
Автор

thats great tutorial, how to convert this query into stored procedure??

muhammadridhoprakarsa
Автор

hey my query is getting error the same i have tried in my ssms
plz help

dineshzoomyt