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

3.8 not identifying temp table

MikeyCMikeyC Posts: 249 Bronze 3
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.