SQL Server Home
SQL Server Management Studio IntelliSense not working for subqueries on table-valued functions
6/8/2009 1:27:14 PM
User(s) can reproduce this bug
In SQL Server Management Studio IntelliSense when including subquery based on table-valued function IntelliSense incorrectly marks returned variables as ambigious and marks function as "invalid object name". If table-valued function has an alias then IntelliSense says that "identifier could not be bound". Please see attached screenshots for reference.
SQL Server 2008 SP1
Tools (SSMS, Agent, Profiler, etc.)
Windows XP Professional
Operating System Language
Steps to Reproduce
Create a table-valued function to return several fields.
In a query editor try using results of the function as a subquery.
The field names are underlined as incorrect.
Correctly spelled field names should not be underlined as incorrect.
to post a comment.
Please enter a comment.
on 4/22/2011 at 11:57 AM
Thanks for reporting this issue. We have fixed this issue in the upcoming Denali CTP.
on 3/17/2010 at 4:34 AM
I'm experiencing this problem for Scalar based functions, intellisense doesn't seem to pickup on the fact that I have my own functions it just says: "xxx is not recognised as a built in function name". When I run the query, it all works as expected.
Intellisense seems to display table listings OK, yet not other objects.
to post a workaround.
Please enter a workaround.
on 3/17/2010 at 4:35 AM
I believe RedGate have a tool that does something similar, maybe that's worth a look.
© 2013 Microsoft