brackets surrounding alias in join

BurkeBurke TeXaSPosts: 8 Bronze 1
edited September 28, 2009 4:47AM in SQL Prompt Previous Versions
if i input a query like:
SELECT	*
FROM	[dbo].[Name] n
	INNER JOIN [dbo].[Activity] a

and then type ON and pick a join, it inputs like:
SELECT	*
FROM	[dbo].[Name] n
	INNER JOIN [dbo].[Activity] a	ON [n].[ID] = [a].[ID]

in previous versions, the alias would not be bracketed which is what i prefer. i can't find a setting to change this behavior, is it possible to have it like:
SELECT	*
FROM	[dbo].[Name] n
	INNER JOIN [dbo].[Activity] a	ON n.[ID] = a.[ID]

thanks,
bc

Comments

  • Thanks for your post and apologies for the inconvenience caused by this issue.

    This issue has been previously reported by couple of customers and logged in our internal tracking system (SP-2769). I have added your comment to this issue.

    It will be reviewed for a future release of SQL Prompt.

    Kindly let us know if you have any issues or questions regarding the product,I'll like to help.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
Sign In or Register to comment.