Additional AS

Hi Redgate Team,

SQL Prompt will add an AS in the end formatting the following code

SELECT  ((4.2 * 29) + 68 )* 8 + (6 * 34)

SELECT  ((4.2 * 29) + 68 )* 8 + (6 * 34) AS

Version 9.0.9.3951

Thanks for fixing this!

Torsten

torsten.strauss February 11, 2018 16:09

1 comment

This doesn't occur for me. I just get a semicolon at the end. Perhaps you have a setting item that causes this? I've pinged support on tracking which one it might be. Either way, definitely a bug that's happening in some situations.

way0utwest February 13, 2018 16:21

0

Please sign in to leave a comment.

How can we help you today?