keywords as alias issues

ggeier

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

select top 1  [start] = 'wwww', [end] = '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', [end] = 'xxxx'
from sys.objects o;

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

Harry Frankish

Hi ggeier

Thanks for reporting this. We've reproduced the issue and are working on a fix.

Cheers
Harry

Harry Frankish

Hi ggeier

I think this is fixed in this build (http://download.red-gate.com/EAP/SQLPro ... .0.224.exe)

Please let us know if this fixes the issue for you

Cheers
Harry