Competition: What’s your favorite Redgate tool? Enter now.

7.3.0.775 - CREATE OR ALTER doesn't appear to work

J LJ L Posts: 5 Bronze 1
edited January 20, 2017 5:12AM in SQL Prompt
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.

Comments

  • 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
  • J LJ L Posts: 5 Bronze 1
    That's done the trick, thanks for your help.
Sign In or Register to comment.