What are the challenges you face when working across database platforms? Take the survey
Options

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

  • Options
    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
  • Options
    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
  • Options
    Andrei RAndrei R Posts: 14 Bronze 1
    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.