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

Formatting bug when expanding * related to temp table

MikeyCMikeyC Posts: 249 Bronze 3
edited October 15, 2007 2:01PM in SQL Prompt Previous Versions
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

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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!
Sign In or Register to comment.