On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.
How to get SQL Prompt to add (NOLOCK) when inserting a join?
Consider the following snippet:
When I select CustomerPerson from the dropdown, is there a way to get SQL Prompt to add it with (NOLOCK) statement? I've looked through options and haven't found anything obvious.
P.S. I am on SQL Prompt 7.5 and this is SSMS 17.9.1
0 · Share on Twitter