How can we help you today? How can we help you today?

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

rgelb
0

Comments

2 comments

Sort by
  • 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




    Dan_J
    0
  • 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.
    mjorgenson
    0

Add comment

Please sign in to leave a comment.