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

Formatting bug when expanding * related to temp table

Given this code:

SELECT
'' AS [Federal Tax ID]
INTO #Test

SELECT *<cursor> FROM #test

If you hit TAB to expand the * to list all the fields it makes the select statement look like this:

SELECT Federal Tax ID] FROM #test

I have the formatting option set to not put [] around fields by default, so they should only be there when necessary, but they certainly shouldn't be doubled, or tripled. ;)

I am running SQL Prompt 3.6.0.109
MikeyC
0

Comments

1 comment

Sort by
  • Brian Donahue
    Thanks for your post. I've logged this as an issue for development to fix. SQL Server 2005 has been throwing these extra brackets into DDL, but all of Red Gate's SQL tools have workarounds for this. It appears you have found an exception!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.