How can we help you today? How can we help you today?

Temp Table and Suggestion

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...
MikeyC
0

Comments

2 comments

Sort by
  • Anu D
    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?
    Anu D
    0
  • MikeyC
    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.)
    MikeyC
    0

Add comment

Please sign in to leave a comment.