Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

63 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Greg Bacchus shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Sduval commented  ·   ·  Report

    Check out SSMS Boost, I use it in tandem with SQL complete and the two apps together have really made SSMS so much better

  • Sebastian commented  ·   ·  Report

    This suggestion is 7 years old. I would have considered your product but it appears you're not too keen on implementing user requests.

  • Martin commented  ·   ·  Report

    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  ·   ·  Report

    Definitely something I'd like to see as well.

  • Mesut YILDIRIM commented  ·   ·  Report

    Also we need this improvement. (nolock) is used almost all queries. It would be useful.

  • Jason commented  ·   ·  Report

    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.