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

7.3.0.775 - CREATE OR ALTER doesn't appear to work

I have the latest Microsoft SQL Server Management Studio 13.0.16100.1 and SQL Prompt 7.3.0.775.
According to the release notes, the CREATE OR ALTER syntax should now be supported. However, when I take any script, which SQL Prompt is able to format, and change the CREATE FUNCTION statement (or an ALTER FUNCTION statement) into a CREATE OR ALTER statement, I get the following error when attempting to format SQL:
Error laying out sql

SQL Prompt was unable to complete this operation.
Problem areas have been highlighted

The OR is highlighted but the code itself runs without issue so I know that it is syntactically correct. This happens with both functions and stored procedures.
j
0

Comments

2 comments

Sort by
  • Harry Frankish
    Hi J L

    Sorry you're having problems with SQL Prompt.

    Can I check if you're using the new formatting styles? The new formatting feature which should support CREATE OR ALTER is not on by default. You can turn it on in the options menu (SQL Prompt > Options > Labs > Experimental features > Use new formatting styles)

    Cheers
    Harry
    Harry Frankish
    0
  • J L
    That's done the trick, thanks for your help.
    J L
    0

Add comment

Please sign in to leave a comment.