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

rgelb

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

Dan_J

Hi @rgelb

Thank you for reaching out to us regarding this.

Unfortunately this is not currently possible. This is something that was requested/raised in 2019, however it was decided that it wasn't a favorable change to make. The details are outlined on this uservoice page - https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/2314571-option-to-add-with-nolock

mjorgenson

Why couldnt the (NOLOCK) feature just be a flag in the settings?  Is it possible to add it to snippets currently or is there any way to do this?  I need it 100% of the time while working in production.