SQL Intellisense doesn’t work with CAST
If you find this behaviour very frustrating then please vote
https://connect.microsoft.com/SQLServer/feedback/details/614130/intellisense-doesnt-work-with-cast
The problem is that CAST invokes the intellisense drop down when you type AS, when it shouldn’t. What then happens is if you have an object or database that is starts with the same letters as the data type i.e. DATEADD for DATE and XML_NAMESPACES for XML.
What should happen is the intellisense should either include all the data types in the list or ideally only display datatypes in the list (that would be really useful).
There is a work around that is to create a database called xml and one called date but thats not really an appropriate work around.
If you find this behaviour annoying then please vote
https://connect.microsoft.com/SQLServer/feedback/details/614130/intellisense-doesnt-work-with-cast