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

Query hints don't auto-complete?

If I type the following query:

SELECT * FROM tablename WITH (

I don't get any hint suggestions. I was expecting a list of FAST, INDEX, NOLOCK, NOWAIT etc, but there's nothing.

Even If I start typing a hint, it doesn't auto-complete.

Is there an option I need to enable somewhere, or are hints not a supported feature?

Ta,

- Lee
leedavies
0

Comments

4 comments

Sort by
  • Eddie D
    Thank you for your post into the forum.

    SQL Prompt 3.* does not prompt the table hints.

    I will check with the SQL Prompt development team to see if this is still the case in new version of SQL Prompt, version 4 that is to be released within the next couple of weeks.

    If not I will create a feature request to add this functionality.

    Many Thanks
    Eddie
    Eddie D
    0
  • Eddie D
    Hi

    You will be pleased to read that this problem is resolved in SQL Prompt V4 due to be released within the next 10 to 14 days.

    I will update this forum post upon the release of SQL Prompt V4.

    Many Thanks
    Eddie
    Eddie D
    0
  • leedavies
    Thanks for the update Eddie!

    We're now running SQLPrompt v4.0 and table hints work beautifully.

    Thanks SO much!!!!
    leedavies
    0
  • Eddie D
    Thank you for your reply and excellent news that SQL Prompt 4 has resolved your table hints issue.

    I will now close the support call created. Please do contact us if you need our help and assistance in the future.

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.