spaces

torsten.strausstorsten.strauss Posts: 271 Silver 3
edited February 16, 2017 6:39AM in SQL Prompt
Hi !

Formatting the following statement for example will lead to additional spaces:

SELECT * FROM sys.all_sql_modules WHERE uses_native_compilation = 1;
GO

--formatted
SELECT * FROM sys.all_sql_modules WHERE uses_native_compilation = 1;
GO

I guess this is not the expected behavior...

Comments

  • Hi Torsten

    I can't tell where the additional spaces are in your example. Please could you highlight where they are? Sorry if I'm missing something obvious!

    Many thanks
    Harry
  • Hi Harry,

    you are right - it is caused by the formatting here in the thread ;)

    SELECT * FROM sys.all_sql_modules WHERE uses_native_compilation = 1;

    will formatted to

    SELECT_ * FROM_ sys.all_sql_modules WHERE_ uses_native_compilation = 1;

    _ replaces the space.
  • Thanks for reporting this formatting issue Torsten. We've got this logged as SP-6091 and we will get back to you when we have an update.
    Michael Clark
    Technical Lead, SQL Monitor
Sign In or Register to comment.