Download the script for this example from here: drive.google.com/drive/folder...
Жүктеу.....
Пікірлер: 4
@muskanarora2671Ай бұрын
Very informative
@cloudanddatauniverse
Ай бұрын
Thank you for watching
@VictorBoneyАй бұрын
In previous examples of this video, we used the qualifiers as inserted or deleted, however those qualifiers are not there in the Merge statement. We are simply using Output S.ProductKey, S.ProductName - still we are getting the result returned. What is making that work in the Merge statement is not clear
@cloudanddatauniverse
Ай бұрын
In merge we have action keyword which returns what actions the merge statement has performed like insert, update , delete
Пікірлер: 4
Very informative
@cloudanddatauniverse
Ай бұрын
Thank you for watching
In previous examples of this video, we used the qualifiers as inserted or deleted, however those qualifiers are not there in the Merge statement. We are simply using Output S.ProductKey, S.ProductName - still we are getting the result returned. What is making that work in the Merge statement is not clear
@cloudanddatauniverse
Ай бұрын
In merge we have action keyword which returns what actions the merge statement has performed like insert, update , delete