CREATE OR ALTER not supported

NedOtter

Greetings,

SQL Server 2016 supports the syntax: CREATE OR ALTER <schema.objectname>

but it appears that SQL Prompt doesn't support that, as it responds with:
"Error laying out sql
SQL Prompt was unable to complete this operation.
Problem areas have been highlighted."

I'm running SQL Prompt version 7.5.0.787

Thanks --

Michael Clark

Hi Ned,

Would it be possible to try our new formatting engine and let us know if the problem still occurs?

This is currently an experimental feature which you can turn on by going to "SQL Prompt > Options > Labs > Experimental Features" and selecting the "Use new formatting styles" checkbox.

Best,

Michael Clark
Technical Lead, SQL Prompt

NedOtter

Hi Michael,

Thanks for your help --

When I enable the new formatting option, attempting to format CREATE OR ALTER still fails.

Ned

Andrei R

Hi Ned,

Could you post a sample script that fails to format using SQL Prompt ?

For example, this script is formatted successfully:

CREATE OR ALTER PROCEDURE Test.procTest
AS
BEGIN
    PRINT (1);
END;