No IntelliSense for OPTION in Procedure anymore

torsten.strauss

Hi Redgate Team,

The IntelliSense for "Option" is not working anymore when creating a procedure

CREATE PROCEDURE Sales @MaxOrderDate datetime

AS

SELECT TOP 10000

sod.SalesOrderID, sod.OrderQty, sod.UnitPrice, soh.OrderDate

FROM

memory_grant_feedback.SalesOrderDetailMedium sod

INNER JOIN

sales.salesorderheader soh

ON

sod.SalesOrderID = soh.SalesOrderID

WHERE

soh.OrderDate < @MaxOrderDate

ORDER BY

sod.OrderQty  

opt   <= no intellisense

GO

Thanks for fixing!

Torsten (MVP)

Version 10.11.10.27545 

Dan_J

Hi @torsten.strauss

Thanks for reaching out to us regarding this.

I've tested this with the script you have provided and initially wasn't able to reproduce what you are describing here, however after formatting the script (applying my active style) I now can. 

I'm going to engage with our development team on this and will come back to you again as soon as I can. In the mean time, would it be at all possible for you to provide your active Style file in case this is helpful for troubleshooting?

torsten.strauss

Hi Dan!

Thanks for your support.
I attached the style sheet.

Dan_J

Hi @torsten.strauss

Thanks for providing your style!

I thought I had been able to reproduce what you're seeing here, however I hadn't realised that when I formatted the code it added a semi-colon at the end of sod.OrderQty on line 14. This semi-colon then stopped OPTION from being suggested. As soon as I removed the semi-colon OPTION is then suggested.

Just to clarify, do you not see OPTION suggested even when there is no semi-colon in place at the end of the previous line?

torsten.strauss

Hi Dan!
Yes, the problem is there without the semicolon ...

Dan_J

Hi @torsten.strauss

Thanks for your clarification on this.

Strangely I still cannot reproduce this without a semi-colon in place.

Would you mind confirming what version of SSMS you are currently using? Also, would you mind installing the very latest version of SQL Prompt (v.10.11.11 - https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.11.27632.exe) to see if this issue persists for you?

torsten.strauss

Hi Dan,

it seems that the latest update fixes the issue. I will inform you when it occurs again.
Thanks!

Dan_J

Hi @torsten.strauss

That's great, I'm glad to hear the latest update had fixed this for you!

Thanks for coming back to us to confirm this.