Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

How to get SQL Prompt to add (NOLOCK) when inserting a join?

rgelbrgelb Posts: 45 Bronze 4
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


Sign In or Register to comment.