Field Suggestions That Start with a Number

MikeyC

It would be nice if SQL Prompt would offer suggestions for fields that start with numbers when you start typing the field name even if you leave off the [.

SELECT 
  1 AS [1Field], 
  2 AS [2Field], 
  3 AS [3Field] 
INTO #Test; 

SELECT 
  <cursor> 
FROM #Test;

At this point if you get suggestions it will suggest the three fields, but you say type a 1 you get no suggestions. (If you type a [1 you get the correct suggestion.) It is especially annoying because it is showed but when you start typing is disappears.

Any chance that SQL Prompt can be updated to so that it will continue to suggest appropriate fields?

Chris Auckland

I see what you mean.

I have logged this as a bug with SQL Prompt. Hopfully it will be addressed in a future version of the tool.

For you reference, the bug tracking code for the issue is SP-2879.