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

Improper syntax for table variables

When I bring up SQL Prompt intellisense from this point:
DECLARE @Table TABLE ( ID INT ) 
INSERT  INTO @Table
        ( ID 
        )
        SELECT TOP 10
                object_id
        FROM    sys.all_objects

SELECT  *
FROM    sys.all_objects
WHERE   object_id IN ( SELECT   ID
                       FROM     @T

...and let it autocomplete, it results in this:
DECLARE @Table TABLE ( ID INT ) 
INSERT  INTO @Table
        ( ID 
        )
        SELECT TOP 10
                object_id
        FROM    sys.all_objects

SELECT  *
FROM    sys.all_objects
WHERE   object_id IN ( SELECT   ID
                       FROM     [@Table] )

...and that is just NOT proper syntax for selecting from a table variable, there should be no squared brackets. Running the statement (with the closing parentheses) will result in:
(10 row(s) affected)
Msg 208, Level 16, State 1, Line 6
Invalid object name '@Table'.

When using SQL Prompt to auto-complete the insert into a the table variable, it works correctly.
blitzd
0

Comments

1 comment

Sort by
  • chriskelly
    Thank you for your post.

    It looks like you have encountered a bug in the tool. I have therefore logged a bug report with the developers. Hopefully they will be able to come up with a fix for the next release. Unfortunately, I cannot yet say when this release will come.
    chriskelly
    0

Add comment

Please sign in to leave a comment.