Скачать
SQL Merge statement step by step guide|
Автор: Data Toolkitt
Загружено: 2025-08-06
Просмотров: 1955
Описание:
Welcome to Data Toolkitt! This channel is dedicated to helping data engineers master essential tools and techniques, from ETL processes to cloud platforms and big data technologies.
Using merge statement we can insert, update and delete data in a single statement.
SQL server-
merge into target_emp tgt
using source_emp src
on (tgt.emp_id = src.emp_id)
when matched then update
set tgt.salary = src.salary
when not matched by target then
insert values (src.emp_id,src.emp_name,src.salary)
when not matched by source then
delete;
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
