What are the challenges you face when working across database platforms? Take the survey

brackets surrounding alias in join

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

and then type ON and pick a join, it inputs like:
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:
FROM	[dbo].[Name] n
	INNER JOIN [dbo].[Activity] a	ON n.[ID] = a.[ID]



  • Options
    Anu DAnu D Posts: 876 Silver 3
    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: support@red-gate.com
Sign In or Register to comment.