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

format error

Hi Redgate Team,

SQL Prompt will report an error when trying to format the following statement

CREATE NONCLUSTERED COLUMNSTORE INDEX [NCLCSI_product_price_latest_ID_product_price_latest] ON [products].[product_price_latest]
(
[ID_product_price_latest]
)
WHERE ([ID_site_to_product]=(-1))
WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [Data]
GO

Thanks for fixing it!
Torsten
torsten.strauss
0

Comments

2 comments

Sort by
  • squigley
    Hello Torsten,
    Thanks for your inquiry and sorry to hear about your issue with the SQL Prompt tool.
    I can confirm that I also getting a formatting error on my end, I'll be sure to escalate this appropriately and let you know of our next steps.

    Thanks!
    squigley
    0
  • squigley
    Hello Torsten,
    Thank you for your patience with this.
    I can happily confirm from the developers that your issue should now be fixed in the latest version which you can grab here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.5.6.17542.exe

    Please let me know if the fix works on your end.

    Thanks!
    squigley
    0

Add comment

Please sign in to leave a comment.