OVER () formatting

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

OVER () formatting

Postby chrisw13 » Mon Jul 01, 2013 4:09 pm

When formatting TSQL with a n OVER() statement, the following line is aligned with the () rather than to the left...

An arbitrary example. You'll need to view in fixed width font (ssms) to see alignment.

Code: Select all
-- sys.indexes alligned propertly under *
SELECT  *
FROM    sys.indexes


-- qty2, * and sys.indexes improperly alligned
SELECT  qty = COUNT(*) OVER ()
                            ,qty2 = SUM(CAST(is_unique AS INT)) OVER ()
                                                                     ,*
FROM                                                                  sys.indexes

-- Using comments to help formatting, but there's still a stair step affect
SELECT  qty = COUNT(*) OVER --
        ()
        ,qty2 = SUM(CAST(is_unique AS INT)) OVER --
         ()
         ,*
FROM      sys.indexes

-- More comments to provide more accurate formatting
SELECT  qty = COUNT(*) OVER --
/*  */ ()
       ,qty2 = SUM(CAST(is_unique AS INT)) OVER --
/*  */ ()
       ,*
FROM    sys.indexes


Currently using SqlPrompt 6.0.0.71 EAP, but same issue in v5.x
chrisw13
 
Posts: 3
Joined: Mon Jul 01, 2013 3:56 pm

Postby Manfred.Castro » Tue Jul 02, 2013 5:55 pm

This would be considered a formatting feature request.
You can direct feature requests to our uservoice forums.
http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest