Query hints don't auto-complete?

leedaviesleedavies Posts: 10
edited August 13, 2009 3:37PM in SQL Prompt Previous Versions
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

Comments

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Thanks for the update Eddie!

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

    Thanks SO much!!!!
  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.