How can we help you today? How can we help you today?

INSERT INTO format

Is it possible to specify the format of the auto-inserted code of the INSERT INTO statement so that the field names are all on the same line?
Like this:
INSERT INTO Table (Field1, Field2, Field3)
VALUES (Value1, Value2, Value)
Gian
0

Comments

2 comments

Sort by
  • Dan_J
    Hi @Gian

    Thanks for reaching out to us regarding this.

    The best way to achieve this is to create a new Style (SQL Prompt > Active Style > Edit Style) and, under the INSERT options, set 'Place subsequent columns on new lines' to 'Never', and select the desired brackets layout, as show in the screenshot below. You will need to do this for both the Column list and the Values list.





    Dan_J
    0
  • Gian
    Hi Dan.
    That's wonderful!
    Grazie :)

    Ciao
    Gian
    0

Add comment

Please sign in to leave a comment.