Options
7.3.0.775 - CREATE OR ALTER doesn't appear to work
J L
Posts: 5 Bronze 1
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:
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.
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
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