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

BUG SQL Promt 9.0.2.3223 On Formatting SQL code

rudymmrudymm Posts: 1 New member
Here is an example of the code:
SELECT 
somez = (
	SELECT 'val1'	AS 'v1'
	, 'val2'		AS 'v2'
	, 'val3'		AS 'v3'
	FOR XML PATH(''), TYPE)

After trying to format it I get:
SELECT 
(
	SELECT 'val1'	S  as v1
	, 'val2'		S  as v2
	, 'val3'		S  as v3
	FOR XML PATH(''), TYPE) as somez ;
Tagged:

Comments

Sign In or Register to comment.