How can we help you today? How can we help you today?

Suggestions from Table Variables

Hi

If I create a Table Variable , should I be seeing normal suggestion lists from the columns
eg

DECLARE @... TABLE
(
Id INT ,
TestName VARCHAR(50)
)



if that were Select * from <space> I would get the whole Table suggestion list , in the case of a Table Vaiable I get Nothing, adding the @ still nothing

I need to do a Cnt Space to show the Suggestions , then it pops to my @... table as I would expect

Same goes for Insert Into , you need to go the Ctr Space route

Am I missing a setting ?

Or is this not supported

Mike
MikeONeill
0

Comments

3 comments

Sort by
  • MikeONeill
    PS

    It seems to work normally if

    CREATE TABLE #Test
    (
    Id INT ,
    TestName VARCHAR(50)
    )

    SELECT
    Id ,
    TestName
    FROM
    #Test AS t

    Mike
    MikeONeill
    0
  • jbeechii
    It workes fine when I use table variables.
    jbeechii
    0
  • Paul Stephenson
    Hi,

    I've had a play with this and it seems that if you type quickly -- so that you've typed the @ before the table names suggestions box appears -- then indeed you have to press ctrl-space to force the box to pop up.

    When I pause after typing FROM, the Suggestions box appears with the full list of table names. When I then type an @, the list is filtered to @... as you'd expect.

    This behaviour doesn't seem to happen when table names begin with a letter, so it does look like a (pretty minor) bug.

    Regards,
    Paul
    Paul Stephenson
    0

Add comment

Please sign in to leave a comment.