SQLinForm SQL Formatter

Posts: 13

kmpel

Topic starter

Jan 27, 2026 11:03 pm

(@kmpel)

Member

Joined: 7 months ago

[#148]

Hi, when I use SELECT TOP, the first column is immediately after the TOP clause. How can I have it below SELECT? Also, it would be amazing if the first column_name is aligned (one character to the right) with the rest of the columns, which have a comma as the first character. Please see the code and expected behaviour below.

Thank you

DECLARE @TopCount INT = 300

SELECT TOP (@TOPCOUNT) JournalId = jr.JournalId
    ,CategoryId                  = jr.CategoryId
    ,AccountTransactionId        = jr.AccountTransactionId
    ,ExpenseTransactionId        = jr.ExpenseTransactionId
FROM schema.table jr

SELECT TOP 300 JournalId  = jr.JournalId
    ,CategoryId           = jr.CategoryId
    ,AccountTransactionId = jr.AccountTransactionId
    ,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table jr


SELECT
    JournalId             = jr.JournalId
    ,CategoryId           = jr.CategoryId
    ,AccountTransactionId = jr.AccountTransactionId
    ,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table           jr


/*------------------------------------
--expected behaviour

DECLARE @TopCount INT = 300

SELECT TOP (@TOPCOUNT) 
     JournalId            = jr.JournalId
    ,CategoryId           = jr.CategoryId
    ,AccountTransactionId = jr.AccountTransactionId
    ,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table jr

SELECT TOP 300 
     JournalId            = jr.JournalId
    ,CategoryId           = jr.CategoryId
    ,AccountTransactionId = jr.AccountTransactionId
    ,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table jr


SELECT
     JournalId            = jr.JournalId
    ,CategoryId           = jr.CategoryId
    ,AccountTransactionId = jr.AccountTransactionId
    ,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table           jr

*//*------------------------------------

3 Replies

Posts: 13

kmpel

Topic starter

Jan 30, 2026 11:30 pm

(@kmpel)

Member

Joined: 7 months ago

The recent 2026-01-29 version moves the first column to the second row. But Top N stays before the column name, which is less readable. Is there any chance to keep TOP N after the SELECT and move the first column to the next row, please?

DECLARE @TopCount INT = 300

SELECT
    TOP (@TopCount) JournalId = jr.JournalId
   ,CategoryId                = jr.CategoryId
   ,AccountTransactionId      = jr.AccountTransactionId
   ,ExpenseTransactionId      = jr.ExpenseTransactionId
FROM schema.table               jr


/* SUGGESTED BEHAVIOUR

DECLARE @TopCount INT = 300

SELECT TOP (@TopCount) 
    JournalId            = jr.JournalId
   ,CategoryId           = jr.CategoryId
   ,AccountTransactionId = jr.AccountTransactionId
   ,ExpenseTransactionId = jr.ExpenseTransactionId
FROM schema.table          jr

*/

jr8.txt

Reply

Posts: 295

Guido

Admin

Feb 01, 2026 11:04 pm

(@admin)

Member

Joined: 5 years ago

Hi @kmpel,

will investigate with the linebreak before TOP keyword.

For the alignement of the 1 column with the comma of the following lines please try these options inthe Lists Tab

Reply

Posts: 295

Guido

Admin

Feb 01, 2026 11:31 pm

(@admin)

Member

Joined: 5 years ago

the bug with the linebreak after top keyword was a typo in my regex 🙁

Please downoad ssms22 Installer Release 2026.02.01.2

Reply

SELECT TOP - first column name below