How can we help you today? How can we help you today?

SQL Prompt - V10.6.16.21150 - SELECT TOP 100

Hey
In an older version of SQL Prompt I could write
SELECT TOP 100 Col1, Col2, Col3
FROM
But in this version it is
SELECT TOP 100
               Col1, Col2 Col3

What option(s) do I need so the column list is on the same as TOP 100. If I remove TOP 100 it works. I've tried an everything seems to be set to Never for moving to a new line
Thanks
Robin Dewson
0

Comments

2 comments

Sort by
  • Dan_J
    Hey @...

    Thanks for reaching out regarding this.

    If you deselect 'Add new line after DISTINCT / TOP clause' under the 'Data (DML)' options you should be able to achieve the formatting you are after.



    I hope this helps!


    Dan_J
    0
  • Dan_J
    Hi @Robin_D

    I just wanted to check if you require any further assistance with this?

    Dan_J
    0

Add comment

Please sign in to leave a comment.