On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

Add spaces around parentheses contents

edited November 6, 2017 8:09AM in SQL Prompt
Hi Redgate Team,

The option Parentheses / Spaces / Add spaces around parentheses contents will add spaces / tab where it shouldn't.

-- enabled
SELECT *
FROM sys.fn_dblog (NULL, NULL)
WHERE
[Transaction ID] IN ( SELECT___(tab added)[Transaction ID] FROM
sys.fn_dblog ('359:2429:26', '359:2429:26')
);
GO

-- disabled
SELECT *
FROM sys.fn_dblog (NULL, NULL)
WHERE
[Transaction ID] IN (SELECT [Transaction ID] FROM
sys.fn_dblog ('359:2429:26', '359:2429:26')
);
GO

I guess this is not intended.

BTW It would be nice to have formatting control about the subquery - it looks really bad comparing to the rest ...

Thanks!

Torsten

Comments

Sign In or Register to comment.