What are the challenges you face when working across database platforms? Take the survey

Temp table doesn't trigger suggestion

MikeyCMikeyC Posts: 249 Bronze 3
edited August 24, 2009 5:38AM in SQL Prompt Previous Versions
Given this code:
SELECT 1 AS field
INTO #Temp

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.


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for the post.

    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.