keywords as alias issues

When using the "Format SQL" feature, it's failing/removing brackets when the alias is a SQL keyword.

select top 1  &#91;start&#93; = 'wwww', &#91;end&#93; = 'xxxx'
from sys.objects o

select top 1  'wwww' as 'start','xxxx' as 'end'
from sys.objects o

formats to:

select top 1  start = 'wwww', &#91;end&#93; = 'xxxx'
from sys.objects o;

select top 1  start = 'wwww',end = 'xxxx'
from sys.objects o;

ggeier January 11, 2017 09:25

2 comments

Please sign in to leave a comment.

How can we help you today?