Temp table doesn't trigger suggestion
MikeyC
Posts: 249 Bronze 3
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.
Comments
I have logged this issue in our internal tracking system whose unique Id is SP-2779 so that it will be addresed in our future release.
Apologies for the inconvenience caused by this issue.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com