Given this code:
SELECT 1 AS field
INTO #Temp
SELECT
*
FROM <cursor>
If you type a # nothing is suggested, even as you continue with type Temp nothing is suggested. If you hit ctrl-space suggestions come up that include the temp table.
Now if the cursor is next the the M in from and you type a space suggestions are triggered. They are also triggered if you start typing anything other than a #, so it just that # doesn't trigger suggestions when it should.
SELECT 1 AS field
INTO #Temp
SELECT
*
FROM <cursor>
If you type a # nothing is suggested, even as you continue with type Temp nothing is suggested. If you hit ctrl-space suggestions come up that include the temp table.
Now if the cursor is next the the M in from and you type a space suggestions are triggered. They are also triggered if you start typing anything other than a #, so it just that # doesn't trigger suggestions when it should.