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?

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

Answers

Sign In or Register to comment.