Temp Table and Suggestion

MikeyC

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

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?

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.)