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

SQL Prompt Formatting Off not applying to a VALUES construct

a.higginsa.higgins Posts: 90 Bronze 2
edited November 1, 2016 3:32PM in SQL Prompt
Using the new switch 'SQL Prompt Formatting Off' to keep a list of attributes in a VALUES constructor from being formatted, I noticed that the comments I'd placed between statements are being moved to the preceding line, and the comma is being placed on a new line.

Original query:
SELECT y
FROM (VALUES 
		-- SQL Prompt Formatting Off
			-- Thing 1
				(1),
			-- Thing 2
				(2)
		-- SQL Prompt Formatting On 
) AS x(y)

Formatted query:
SELECT x.y
FROM
	(
		VALUES
		-- SQL Prompt Formatting Off
			-- Thing 1
				(1)-- Thing 2
			,
				(2)
		-- SQL Prompt Formatting On 
	) AS x (y)

Comments

Sign In or Register to comment.