On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

CREATE OR ALTER not supported

NedOtterNedOtter Posts: 5 New member
edited March 27, 2017 5:12AM in SQL Prompt
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 --

Comments

  • 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
    Michael Clark
    Technical Lead, SQL Monitor
  • NedOtterNedOtter Posts: 5 New member
    Hi Michael,

    Thanks for your help --

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

    Ned
  • 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;
    
Sign In or Register to comment.