Space between comma and field name in SELECT

5 Posts
2 Users
0 Reactions
2,726 Views
Posts: 2
 Paul
Topic starter
(@paul)
Member
Joined: 12 months ago
[#138]

Im new to this but I believe I have all my settings correctly configured to create the output I want.

Here is my input query:

SELECT field1 ,field2, field3 , * FROM table1

And my output looks like this

SELECT field1
    , field2
    , field3
    , *
FROM table1

Where I want to see this (without the space)

SELECT field1
    ,field2
    ,field3
    ,*
FROM table1

 
Here are the settings I currently have configured which seem relevant to this conversation:

  • General -> General Indentation = 4
  • General -> Alignment -> Align Comma = checked
  • General -> White Spaces -> White Spacces (typo) -> Around Commas = No Spaces
  • General -> White Spaces -> Remove unnecessary White Spaces = checked
  • SQL -> Alignment -> Indentaion = General Indentation
  • SQL -> Select -> I dont think my configuration issue has to do with these settings
  • SQL -> Select -> Lists -> Linebreaks -> Before Comma = checked
  • My version: SQLinFormDesktop: 6.25.5.18 - Parser 6.25.05.18

Also, when I execute this on the SQLinForm Desktop it works just the way I want it.  However, when I execute this on SSMS is when my spacing problem shows up.

Any thoughts?


4 Replies
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

Hi Paul,

please try this

 

grafik

Regards

Guido


Reply
Posts: 2
 Paul
Topic starter
(@paul)
Member
Joined: 12 months ago

Guido,

Thank you for the quick response!  I have my Lists -> Linebreaks set up just like you suggest.

Within the SQLinForm Desktop app, it works great.  However, in SSMS it's still showing up with the spaces.

Im on SSMS version 20.2.30.0

Do you have any additional thoughts on my issue?  Thanks!


Reply
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

Ok, thanks for the feedback. I need to publish a new version for SSMS20. Will do this tonight

Regards

Guido


Reply
Guido
Posts: 295
Admin
(@admin)
Member
Joined: 5 years ago

Please download the new Release. Please read the installation instructions. They changed.


Reply
Share: