SQL Server Management Studio adds IntelliSense to the MDX, DMX, and XML code editors, but does not add IntelliSense to the most commonly used T-SQL editors, and does not know what m$ is thinking. But it doesn't matter, today I recommend a plugin--sqlassist, which can add T-SQL Server Management Studio, Visual Studio.NET 2003, and Visual Studio 2005 IntelliSense features. The price of the plug-in for $29, you can free trial 30 days.
With this thing later, write a stored procedure or a large section of the SQL statement is very cool, the specific features I do not say, you can see the pictures on the demo, or go to its official website to see more detailed functional description and demonstration.
It is recommended that you download the version of Visual Studio.NET 2003 or Visual Studio 2005 because the version of SQL Server Management Studio is still a beta version and many features are not yet stable.
SQLASISST Official website: http://www.roundpolygons.com
P.S: If you think $29 is too expensive, then I recommend a free T-SQL IntelliSense plugin--sql Prompt. But I think this thing is not sqlasisst easy to use, but how to say is free, always better than nothing.
