How can we help you today? How can we help you today?

brackets surrounding alias in join

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
Burke
0

Comments

1 comment

Sort by
  • Anu D
    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.
    Anu D
    0

Add comment

Please sign in to leave a comment.