What are the challenges you face when working across database platforms? Take the survey
Options

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 

Answers

Sign In or Register to comment.