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

rgelb · December 30, 2020 6:15PM

Consider the following snippet:

Image: https://us.v-cdn.net/6029854/uploads/editor/rf/p91nfm5pax5r.png

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 · January 4, 2021 3:49PM

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 · March 11, 2024 6:32PM

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.

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

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk