58 Merge Statement in SQL Server

No video

58 Merge Statement in SQL Server

Рет қаралды 4,536

Күн бұрын

merge statement in sql server
Download the scripts used in the video from here: drive.google.c...
SQL Server tutorials: • SQL tutorial for begin...
SQL Server Developer Interview questions: • SQL Server Questions
Merge statement in sql server
Understanding the SQL MERGE statement
MERGE (Transact-SQL) - SQL Server
What is MERGE statement in SQL Server?
SQL MERGE Statement
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”

Пікірлер: 31

@vickypatekar9532 4 ай бұрын

Thank you so much sir for vedios and SQL script🙏

@learnssis 4 ай бұрын

Thank you Vicky.

@marcq1588 11 ай бұрын

Nice tutorial about "SQL Merge". Thank you for your sharing :)

@learnssis 11 ай бұрын

Thank you Marc for appreciating.

@hrushikeshkhonde7079 Ай бұрын

Very Helpful vlog ... thanks sir 🙏

@learnssis Ай бұрын

You are most welcome.

@shahiinalam 9 ай бұрын

very nicely explained, Thanks

@learnssis 9 ай бұрын

Thank you Shahin Alam for appreciating this.

@urbanpro2494 11 ай бұрын

Great explanation thank you so much for hardwork.. I watching your videos getting confidence.. one question I have how to send email for more than one person by using script task.. Thanks in advance

@learnssis 11 ай бұрын

Hi, at the moment I don't have a video on sending email to multiple people, you can watch this video where she showed how to send email to multiple people kzfaq.info/get/bejne/rbFpZr12nJ7Hlas.html

@ericsos101 11 ай бұрын

great presentation. and well explained

@learnssis 11 ай бұрын

Thank you Eric.

@abdullahquhtani4247 11 ай бұрын

Great as usual. One request plz if you can do that. How to update data between two servers so that they kept identical? Thank you.

@learnssis 11 ай бұрын

Thank you. if you can create a linked server from one server to another server and then you can use the Merge statement to update data from one server to another server for a sql table. You can also configure replication between 2 servers to keep all tables in Sync or you can create SSIS packages those can sync data from one server to another server.

@abdullahquhtani4247 11 ай бұрын

@@learnssis Highly appreciated and such tutorial for all or some of those solutions you mentioned are NEEDED.

@chavanrajesh4799 5 ай бұрын

Can you explain implement SCD type2 concept using merge query.

@MVinodKumar-tt1tu 7 ай бұрын

Hello Sir, So we have to maintain the staging table empty sir or it can hold data also. As Merge can do all three operations right sir? so any reason for making staging table empty each time. And when we load data from source to SSIS for example so when the data is in SSIS until loading to target tables or SQL Server then it can be called as staging sir?

@learnssis 7 ай бұрын

it depends on the kind of requirement in the project. If you just want to insert\update data from staging table to destination table, then you should empty the staging table in the beginning otherwise it will end up having duplicate records. Sorry I did not get your second question.

@sreelakshmia6762 3 ай бұрын

We can do scd type 2 with merge statement in sql server. But in oracle, how to do insert after update when matched

@learnssis 3 ай бұрын

Sorry I have not worked with Oracle, thus not sure about that. Can you try chatgpt and see if it gives any useful information ?

@0523036 7 ай бұрын

can you please also do SCD2 implementation please which works for all scenarios

@learnssis 7 ай бұрын

I have done SCD type 2 in SSIS. kzfaq.info/get/bejne/bduaZ5lkyNnWpWQ.html

@deepthinandyala8754 10 ай бұрын

Hi Anil. We should use merge statments in excute SQL task in SSIS

@learnssis 10 ай бұрын

yes we can use it in Execute sql task.

@sreedharagandla 10 ай бұрын

Hi in sql i have faced a one question , In a table we have the A,10000 b,5000 c ,2000, again A ,2000 now we need to find the height salary in table and the result should be A, 12000 b,5000 c,2000. can u make a video on this please

@learnssis 10 ай бұрын

This is will be your query create table test(Name varchar(100), Salary int) go insert into test values('A',10000),('B',5000),('C',2000),('A',2000) go select Name, sum(Salary) as TotalSalary from test group by Name

@sreedharagandla 10 ай бұрын

Thanks

@arifamakandar2437 10 ай бұрын

What is difference between merge statment and temporal table

@learnssis 10 ай бұрын

They both are different. Merge statement is used to insert\update data from one table to another table in sql server, while temporal tables are used to keep historical data of a table.

@arifamakandar2437 10 ай бұрын

@@learnssis ok thank you sir

@learnssis 10 ай бұрын

@@arifamakandar2437You are most welcome Arifa.