3.8 not identifying temp table

MikeyC

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

chris.buckingham

Thanks for pointing this out - I have placed this in our bug database as SP-1223 and will get back to about developments.

Brian Donahue

Hi Michael,

This appears to have been fixed in SQL Prompt v4.