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

SQL Prompt 5 and INSERT statements

webrunnerwebrunner Posts: 28 Bronze 1
edited October 27, 2014 5:20PM in SQL Prompt Previous Versions
Hello experts,

When I format SQL for an INSERT statement, the columns in the INSERT clause are always formatted with a line break after each column. But I want them to match whichever format I choose (new line break or not) depending on what the SELECT statement has. I am using a SELECT statement rather than a VALUES clause to provide the insert values, like this:
INSERT INTO MyTable ( col1,
                      col2,
                      col3 )
SELECT col1, col2, col3

Is there any way to have these two formats match, such as:
INSERT INTO MyTable ( col1, col2, col3 )
SELECT col1, col2, col3

or
INSERT INTO MyTable ( col1,
                      col2,
                      col3 )
SELECT col1, 
       col2, 
       col3

Let me know if you need more information.

Thanks for any help!

webrunner
Sign In or Register to comment.