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

Data Statements - formatting with INSERT statement

webrunnerwebrunner Posts: 28 Bronze 1
edited April 10, 2013 6:57PM in SQL Prompt Previous Versions
Hi,

I want to format an INSERT SQL statement with a SELECT statement (not a VALUES statement) without having each column on a new line.

When I highlight the code and choose Format SQL, it puts multiple SELECT statement columns on one line but not the INSERT statements.

For example:
INSERT INTO MyTable ([col1],
[col2],
[col3],
[col4])
SELECT col1, col2, 
col3, col4
FROM MyOtherTable

Is there an option to have the query look like this, with both INSERT and SELECT columns more than 1 to a line?
INSERT INTO MyTable ([col1], [col2],
[col3], [col4])
SELECT col1, col2, col3, col4
FROM MyOtherTable

I tried looking at the options for Data Statements but can't get it to work.

Thanks for any help.

- webrunner

Comments

Sign In or Register to comment.