Temp Table and Suggestion

MikeyCMikeyC Posts: 249 Bronze 3
edited February 28, 2011 12:42PM in SQL Prompt Previous Versions
Given the following code:
/*
SELECT 
	1 AS TestField
INTO #Temp1;
*/

SELECT 
	<cursor>
FROM #Temp1 L

When I hit CTRL-space to bring up suggestions the alias L is not listed as a choice. I understand that because the temp table creation is commented out that SQL Prompt doesn't know about it, but it should at least know about the alias. I assume that SQL Prompt is trying to fully resolve the alias and can't so it doesn't suggest the alias.

I consider this a bug, but you might consider it a design decision/limitation...

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post.

    Can you kindly log your request on SQL prompt's uservoice: Click here

    And then the project manager can directly decide what category this requirement comes under?
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • MikeyCMikeyC Posts: 249 Bronze 3
    I went ahead and did that, but I really don't like using that as a method for suggesting features and reporting bugs. The biggest reason is that you are really limited to posting 10 suggestions since you have to have votes available to post a new one. (I had to take a vote away from something else.)
Sign In or Register to comment.