Query hints don't auto-complete?

leedavies · July 30, 2009 11:10AM

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

Eddie D · July 31, 2009 2:41PM

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 · August 3, 2009 10:48AM

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

leedavies · August 13, 2009 8:40AM

Thanks for the update Eddie!

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

Thanks SO much!!!!

Eddie D · August 13, 2009 3:37PM

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

Query hints don't auto-complete?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk