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

Alignment

Hi!

SQL prompt will format the following code like this
[code]
-- Insert 10 records
WITH cte
AS
    (
        SELECT numbers.col1
        FROM ( VALUES ( 0 )
               ,      ( 1 )
               ,      ( 2 )
               ,      ( 3 )
               ,      ( 4 )
               ,      ( 5 )
               ,      ( 6 )
               ,      ( 7 )
               ,      ( 8 )
               ,      ( 9 )
             ) AS numbers ( col1 )
    )
INSERT dbo.test ( col1, col2 ) SELECT c1.col1, c1.col1 FROM cte AS c1 ORDER BY
                                   1;
GO
[/code]

Order by should sent to a new line and / or 1 should be alignment with Insert?
Looks a bit strange...

Thanks !

Torsten

Version 9.1.5.4619



Sign In or Register to comment.