Add option to include (NOLOCK) when auto-completing
Due to the nature of our data, we use NOLOCK on most of our queries. It would be useful for us to be able to automatically have (NOLOCK) included when part of a statement is auto-completed. It may be useful to have it so that this option can be turned on only in specific databases.
Check out SSMS Boost, I use it in tandem with SQL complete and the two apps together have really made SSMS so much better
This suggestion is 7 years old. I would have considered your product but it appears you're not too keen on implementing user requests.
I use it very often, but there are 2 simply ways now how to solve it:
- in the beginning of query define: set transaction isolation level read uncommitted
- create snnipet (no = with (nolock) )
John Straka commented
Definitely something I'd like to see as well.
Mesut YILDIRIM commented
Also we need this improvement. (nolock) is used almost all queries. It would be useful.
It would be greatly helpful for this have the ability to add (nolock) table hints after a from or join clause. I find that developers and junior T-SQL writers have a hard time remembering to add (nolock) after a from or join.