3.8 not identifying temp table

CodantiMCodantiM Posts: 245
edited September 28, 2009 9:17AM in SQL Prompt Previous Versions
Given this code:

SELECT DISTINCT
*
INTO #Test
FROM MASTER.dbo.spt_values

SELECT *
FROM #<cursor>

SQL Prompt 3.8.0.244 will not have #Test as a suggestion. If you remove DISTINCT it will. Then once you have removed it, you can put it back and it will still have it as a suggestion. (I don't really like having to go through and remove code and put it back so SQL Prompt can work.)

Michael

Comments

Sign In or Register to comment.