Home Dashboard Directory Help
Search

SQL Server Management Studio IntelliSense not working for subqueries on table-valued functions by jhhhj


Status: 

Closed
 as Fixed Help for as Fixed


7
1
Sign in
to vote
Type: Bug
ID: 465372
Opened: 6/8/2009 1:27:14 PM
Access Restriction: Public
1
Workaround(s)
view
3
User(s) can reproduce this bug

Description

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.
Details
Sign in to post a comment.
Posted by Microsoft on 4/22/2011 at 11:57 AM
Hi,

Thanks for reporting this issue. We have fixed this issue in the upcoming Denali CTP.

Thanks,
Dipti.
Posted by Adam Chidgey 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.
Sign in to post a workaround.
Posted by Adam Chidgey on 3/17/2010 at 4:35 AM
I believe RedGate have a tool that does something similar, maybe that's worth a look.
File Name Submitted By Submitted On File Size  
SQL_IntelliSense1.JPG (restricted) 6/8/2009 -
SQL_IntelliSense.JPG (restricted) 6/8/2009 -