Formatting bug when expanding * related to temp table

MikeyC

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

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!