Query hints don't auto-complete?

leedavies

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

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

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

Thanks for the update Eddie!

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

Thanks SO much!!!!

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