MERGE

Question

MERGE

Viewing 4 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

toufeeqt Valued Member Points: 55 More actions · Answer 1

+1 Good Question thought I had it but I was wrong, been using the MERGE statement alot these days but never with Tables having INSTEAD OF triggers

You learn something new each day 🙂

kapil_kk SSC-Insane Points: 21316 More actions · Answer 2

just ware of the fact that MERGE statement should end up with ;

never used Instead OF trigger, its good if anyone you can explain it with an example

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 3

kapil190588 (10/11/2012)
just ware of the fact that MERGE statement should end up with ;
never used Instead OF trigger, its good if anyone you can explain it with an example

Explanation and examples can be found here: http://msdn.microsoft.com/en-us/library/ms175521%28SQL.105%29.aspx

If you still have questions after that, feel free to post those questions here.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Good question, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant