Hello, I am not seeing the expected formatting for INSERT INTO statements. Below I have included my settings and examples of the statements and formatting.
Am I wrong in thinking the INSERT INTO statement should be formatting the same as the SELECT statement below?
SQL Prompt version 7.4.1.603
==============================================================================================================
Format > Data statements
These options apply to SELECT,
INSERT, UPDATE and DELETE statements
New lines - Place the following on a new line:
[x] First Column
[x] Each subsequent column
[x] Contents of parentheses
[x] Closing parentheses
[x] Join condition
[x] Indent subclauses
[ ] Align join condition with JOIN
Subqueries:
[ ] Place derived tables and subqueries on a single line
Indents:
[ ] Align JOIN with FROM
[x] Align SELECT with INSERT
-- this is the table and it formats correctly
CREATE TABLE #myTempTable (
ID INT PRIMARY KEY CLUSTERED
, Name NVARCHAR(50)
, ThisOrThat BIT
)
-- this is what I expected for the INSERT statement
INSERT INTO #myTempTable (
ID
, Name
, ThisOrThat
)
VALUES
(
0
, N'0'
, 0
)
,(
1
, N'1'
, 1
)
-- SELECT is working as expected with the settings
SELECT
ID
, Name
, ThisOrThat
FROM
#myTempTable
-- this is the INSERT statement after formatting
-- it places the columns and values on a single line and wraps them if too long
INSERT INTO #myTempTable
(ID, Name, ThisOrThat)
VALUES
(0, N'0', 0),
(1, N'1', 1)
Hi Nizzy
Am I wrong in thinking the INSERT INTO statement should be formatting the same as the SELECT statement below?
SQL Prompt version 7.4.1.603
==============================================================================================================
Format > Data statements
These options apply to SELECT, INSERT, UPDATE and DELETE statements
New lines - Place the following on a new line:
[x] First Column
[x] Each subsequent column
[x] Contents of parentheses
[x] Closing parentheses
[x] Join condition
[x] Indent subclauses
[ ] Align join condition with JOIN
Subqueries:
[ ] Place derived tables and subqueries on a single line
Indents:
[ ] Align JOIN with FROM
[x] Align SELECT with INSERT
-- this is the table and it formats correctly CREATE TABLE #myTempTable ( ID INT PRIMARY KEY CLUSTERED , Name NVARCHAR(50) , ThisOrThat BIT ) -- this is what I expected for the INSERT statement INSERT INTO #myTempTable ( ID , Name , ThisOrThat ) VALUES ( 0 , N'0' , 0 ) ,( 1 , N'1' , 1 ) -- SELECT is working as expected with the settings SELECT ID , Name , ThisOrThat FROM #myTempTable -- this is the INSERT statement after formatting -- it places the columns and values on a single line and wraps them if too long INSERT INTO #myTempTable (ID, Name, ThisOrThat) VALUES (0, N'0', 0), (1, N'1', 1)