PoorMansTSqlFormatter icon indicating copy to clipboard operation
PoorMansTSqlFormatter copied to clipboard

Bug with formatting when using double quote

Open RRamanaFTI opened this issue 6 years ago • 1 comments

When I use this tool and sometimes need to format a dynamic sql string like the one below:

'select ''.txt'' as fileExt'

and I try to format it wont format much as the whole string is quoted.. but when I remove the begin and end quote for the statement and try to format this below: select ''.txt'' as fileExt I get output SELECT ''.txt '' AS fileExt which introduces a subtle (but nasty for middle tier) with an extra space after .txt !!

could you please fix this bug and let me know when it is checked in

RRamanaFTI avatar Jun 18 '18 19:06 RRamanaFTI

submitted tool bug https://github.com/TaoK/PoorMansTSqlFormatter/issues/200

RRamanaFTI avatar Jun 18 '18 19:06 RRamanaFTI