brackets surrounding alias in join

Burke · September 24, 2009 11:12PM

if i input a query like:

SELECT	*
FROM	&#91;dbo&#93;.&#91;Name&#93; n
	INNER JOIN &#91;dbo&#93;.&#91;Activity&#93; a

and then type ON and pick a join, it inputs like:

SELECT	*
FROM	&#91;dbo&#93;.&#91;Name&#93; n
	INNER JOIN &#91;dbo&#93;.&#91;Activity&#93; a	ON &#91;n&#93;.&#91;ID&#93; = &#91;a&#93;.&#91;ID&#93;

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	&#91;dbo&#93;.&#91;Name&#93; n
	INNER JOIN &#91;dbo&#93;.&#91;Activity&#93; a	ON n.&#91;ID&#93; = a.&#91;ID&#93;

thanks,
bc

Anu D · September 28, 2009 4:47AM

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.

brackets surrounding alias in join

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk