Options
No IntelliSense for OPTION in Procedure anymore
torsten.strauss
Friend of Redgate › Posts: 266 Silver 3
in SQL Prompt
Hi Redgate Team,
The IntelliSense for "Option" is not working anymore when creating a procedure
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
Thanks for fixing!
Torsten (MVP)
Version 10.11.10.27545
Tagged:
Answers
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?
Dan Jary | Redgate Software
Have you visited our Help Center?
Thanks for your support.
I attached the style sheet.
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?
Dan Jary | Redgate Software
Have you visited our Help Center?
Yes, the problem is there without the semicolon ...
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?
Dan Jary | Redgate Software
Have you visited our Help Center?
it seems that the latest update fixes the issue. I will inform you when it occurs again.
Thanks!
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.
Dan Jary | Redgate Software
Have you visited our Help Center?