Merge Byline Endorsement with airSlate SignNow

Merge age statement of work

Hey guys welcome back to the SQL tutorial series. In this session we will work with the merge statement. So the merge statement helps us to perform insert update and delete in just one statement. This means we no longer require multiple statements to perform insert update and delete. And for the merge statement we required two tables; a source table and a target table. So the so table basically contains all the changes which are to be applied to the target table and the target table is that table upon which we'll be implementing all the changes. Now the merge statement basically joins the target table to the source table using a common column in both the tables and based on how the rules match up you can perform insert delete and update operations on the target table. Now let's have a look at the syntax of the merge statement so we'll start with the merge keyword and then give the name of the target table and assign it an alias using the ask keyword then we'll type using and give the name of the source table and also assign it an alias using the ask keyword again. After that we'll type on and then set the join condition then we'll type when matched so if the row is match up based on the join condition then we'll go ahead and update the target table after that we check when not match by target so this basically means that if there are some rows which are present in the source table but not in the target table then we'll go ahead and insert those rows from the source table into the target table and finally we check when not matched by source. So here we are checking if there are some rows which are present in the target table but not in the source table. Then we'll go ahead and delete those rows from the target table and for the practical purpose we'll be using these two tables. So this is our source table with the name employee source and this is a target table with the name employee target so using the merge statement we'll be updating the a salary and e age columns in the table wherever there's a match also insert the records with employee ID 7 and employee ID 8 into the target table from the source table and delete the records with employee ID 4 and employee ID 5 from the target table because they're not present in the source table. So let's go to SQL server and work with the merge statement right so we have our two tables right in front of us this is the employee source table and this is the employ target table and we also have the merge syntax to apply on these two tables. So we'll type merge and then give the name of the target table employee target we'll assign it an alias D similarly we'll...