SQL - Merge

No video

SQL - Merge

Рет қаралды 34,965

James Oliver

Күн бұрын

This video covers how to use the merge statement with t-sql.

Пікірлер: 51

@safkaify7875 23 күн бұрын

Probably the best teaching video I've seen in terms of: Visuals + well paced script + audio on point. Please keep up the good work.

@chriskeo392 Жыл бұрын

Crushed it Visuals + well paced script + audio on point 👑 Content king!

@ottmiller4028 3 жыл бұрын

James, your explanations are lucid and thorough. Thank you for your efforts.

@cidaiha Жыл бұрын

Thank you, PERFECT EXPLANATION !

@Circumvenscion 2 жыл бұрын

Well explained and concise. Please do more of these type of videos, you're great at it!

@JamesOliver 2 жыл бұрын

Thank you for the kind words. Much appreciated. :)

@briancanfield2968 2 жыл бұрын

Agreed

@CrazySw3de 3 жыл бұрын

Great video, easy to understand explanation with clear examples and nice editing.

@sumit-visatotravel8780 4 ай бұрын

Very well explained!

@anawadtom6011 2 жыл бұрын

Simple, clear explanation. Thanks!

@apoorvavanaparthi8853 6 ай бұрын

Thank you so much for this clear and concise explanation!!!!!!! 🙏

@RC-ql5lp 3 жыл бұрын

Great tutorial. I have learn a new command in t-sql.

@Thle009 Жыл бұрын

Thank you for a great tutorial video. The fact that it is still relevance today 2 years later showing just how powerful your video is. Would it be possible for you to make a video on the output and the MergeResults table?

@abbasmuhammed214 Ай бұрын

thank you so much, I appreciate that, and it was very useful

@iliashterev38 6 ай бұрын

I was just about to say this tutorial is awesome and then you went onto the deleted and inserted tables without taking a moment to walk trough the target table after the merge. And I have learned so far that deleted and inserted tables are available only within the scope of the triggers. Which confused me further.

@RainSoundsToConcentrate 9 ай бұрын

Amazing video ,ty 😎

@riccarrasquilla379 Ай бұрын

thanks for the video

@mohammadhaque1873 2 жыл бұрын

Thank you, very nicely explained.

@bobocrazvan-marius801 2 жыл бұрын

Very helpful video, thank you for the explanation!

@maheshbabu6925 2 жыл бұрын

Nice explanation James

@JamesOliver 2 жыл бұрын

Appreciate it very much. :)

@abcxyz6606 3 жыл бұрын

Wow, this is very neat. TY for these.

@emrc9777 Жыл бұрын

Excellent video! ❤

@makeittrades5750 3 жыл бұрын

wow what a cool tutorial, loved it!

@sayfriseup172 Жыл бұрын

Any Idea about 'Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "French_CI_AS" in the equal to operation.

@Renad-bm3ph 3 жыл бұрын

thank you angel

@thomasjordan454 2 жыл бұрын

Awesome video thanks

@Raj-ph1py 3 жыл бұрын

Excellent tutorial

@JamesOliver 3 жыл бұрын

Much appreciated. :)

@chriskeo392 Жыл бұрын

More advanced merge videos?!? And more on how to leverage OUTPUT

@romeokamil 2 жыл бұрын

wow, they were very quick 10 minutes :)

@rntech4541 Жыл бұрын

thanks so much sir. This Solved my proble which made me busy with it since a week,,but could you tell me how to invite this query in c#?

@fo1487 2 жыл бұрын

I liked your video, ty

@DeekshaKatiyar-wn7ub Жыл бұрын

Hey I am facing issues in merge. Getting an error saying "Merge is not valid at this position"....

@sreelakshmia6762 3 ай бұрын

Do you have same in oracle?

@dmitryvlasov931 3 жыл бұрын

Good job!

@israell9320 3 жыл бұрын

Awesome!! thanks

@LearnSalesforceWithPiyush 2 жыл бұрын

How to merge two stored procedures in mysql.

@rapo107 3 жыл бұрын

James... Missing your MSTR videos a lot. Please make videos..🙏

@JamesOliver 3 жыл бұрын

MicroStrategy video coming Monday

@johnli6706 Жыл бұрын

Nice presentation, but you missed the update when only CreditRating changes.

@henrygrip8486 3 жыл бұрын

Why did the result showed you the row with the id 1524 when that one doesnt exist in either of the two original tables.

@romeokamil 2 жыл бұрын

hi did select on top 7 from source table, 1524 was not in top 7 but matched the values for the merge.

@TheSomestuffs 3 жыл бұрын

Good...

@FloKluge Жыл бұрын

Cool video, but the merge did not update a rating change from 1 to 2 or from 2 to 1.

@PedramRasti 3 жыл бұрын

Thank you James! Any idea why a syntax error near the OUTPUT may come up. I did exactly what you did but somehow for the output part i get a syntax error

@tihanapolezari7638 2 жыл бұрын

Because you need to create a new table or temporary table with CREATE statement which contains fields from both tables, including the field for Action. Let's say that target and source have next table structure: BusinessEntityID int, AccountNumber nvarchar(10), Name nvarchar(10), CreditRating int I need to create table #MergeResults like: Create table #MergeResults (BusinessEntityID int, AccountNumber nvarchar(10), Name nvarchar(10), CreditRating int, ActionTaken nvarchar(10), new_BusinessEntityID int, new_AccountNumber nvarchar(10), new_Name nvarchar(10), new_CreditRating int) then the last statement or OUTPUT deleted.*., $action, inserted.* into #MergeResults will work. Hope it will help someone. 😄

@MpT_Head Жыл бұрын

@@tihanapolezari7638 This did help a lot, thanks. James probably should have shown the temp #MergeResults table and also explained how the Output works to put the old and the new data in the correct columns. I haven't really worked with Triggers before so when he said 'If you've worked with Triggers before...' it was remiss not to explain for those who hadn't.