Additional AS

torsten.strauss · February 11, 2018 4:09PM

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

way0utwest · February 13, 2018 4:21PM

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.

Additional AS

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk