I understand this is picky, but I notice that when I use the table hint for HOLDLOCK in a T-SQL MERGE statement that SQL Prompt gives me a green squiggly and says that table hints should be avoided. As a general guideline, I agree.
In the case of the MERGE statement as implemented by Microsoft SQL Server, I have come to understand that if this table hint is not used it leads to race conditions. I would wonder if in this particular case, SQL Prompt would not call it out, and in fact, for SQL Server, actually squiggle me if the hint is missing?
I understand this is picky, but I notice that when I use the table hint for HOLDLOCK in a T-SQL MERGE statement that SQL Prompt gives me a green squiggly and says that table hints should be avoided. As a general guideline, I agree.
In the case of the MERGE statement as implemented by Microsoft SQL Server, I have come to understand that if this table hint is not used it leads to race conditions. I would wonder if in this particular case, SQL Prompt would not call it out, and in fact, for SQL Server, actually squiggle me if the hint is missing?