SQL Server Merge T-SQL Command Two Tables With Same Columns Must See!

Publié le: 08 novembre 2021
sur la chaîne: Software Nuggets

4,426

If you are interested to learn more about SQL Server merge command, this is the correct video to watch!

This video is all about SQL Server merge command. I will show by example how to use this incredible command:
-SQL merge two tables with same columns
-merge statement in SQL example

Source Table - A table that contains all the changes.
Target Table - A different table that will receive all those changes.

Perform Insert, Update and Delete in one statement. This video only shows Insert and Update.

Thank you for dropping in, I hope you'll find all the information you'll need to successfully use this command.

Source code for this video.

create table web (
order_id int,
has_shipped bit
)

insert into web(order_id,has_shipped)
values
(1,'true'),
(2,'true'),
(3,'true'),
(4,'true')

create table production
(
order_id int,
has_shipped bit
)

insert into production(order_id, has_shipped)
values
(1,'false'),
(2,'false'),
(3,'false')

merge production as T
using web as S
on (t.order_id = s.order_id )
when matched then
update SET T.has_shipped = S.has_shipped
when not matched by target then
insert (order_id, has_shipped) values (S.order_id, S.has_shipped);

Sur cette page du site, vous pouvez voir la vidéo en ligne SQL Server Merge T-SQL Command Two Tables With Same Columns Must See! durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Software Nuggets 08 novembre 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 4,426 fois et il a aimé 27 téléspectateurs. Bon visionnage!

113