How can we help you today? How can we help you today?

No IntelliSense for OPTION in Procedure anymore

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 
torsten.strauss
0

Comments

7 comments

Sort by
  • Dan_J
    Hi @....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?
    Dan_J
    0
  • torsten.strauss
    Hi Dan!

    Thanks for your support.
    I attached the style sheet.
    torsten.strauss
    0
  • Dan_J
    Hi @....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?
    Dan_J
    0
  • torsten.strauss
    Hi Dan!
    Yes, the problem is there without the semicolon ...
    torsten.strauss
    0
  • Dan_J
    Hi @....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?
    Dan_J
    0
  • torsten.strauss
    Hi Dan,

    it seems that the latest update fixes the issue. I will inform you when it occurs again.
    Thanks!
    torsten.strauss
    0
  • Dan_J
    Hi @....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.
    Dan_J
    0

Add comment

Please sign in to leave a comment.