This post may be very simple for most of the users of SQL Server 2005. Earlier this year, I have received one question many times - Where is Query Analyzer in SQL Server 2005? I wrote small post about it and pointed many users to that post - SQL SERVER - 2005 Query Analyzer - Microsoft SQL SERVER Management Studio. Recently I have been receiving similar question.
Where is Query Editor in SQL Server 2005?
SQL SERVER 2005 has combined Query Analyzer and Enterprise Manager into one Microsoft SQL SERVER Management Studio (MSSMS).
I have been pointing my users to my previous post so far. One of my reader asked recently is it really true SSMS = QE + EM . I realize that my answer is not complete. SQL Server 2005 Query Editor has many other enhancements over previous versions. There are many standard features also brought over from previous tools. From MSDN I found following list which is quite complete and concise.
Statement auto-completion.
Parameter tipping for system stored procedures and user-defined functions.
Color-coding of Transact-SQL and MDX syntax.
Templates to speed development of the T-SQL.
Editing of execute and parse queries with SQLCMD extensions.
Results presented in either a grid or a free-form text window, or in XML form.
Graphical representation of the showplan information.
Reference : Pinal Dave (http://www.SQLAuthority.com), BOL
pinaldave
Dear Sir,
I am very happy to see ur article on sql-server for the first time. Thank you for providing such helpful article.
How could I fetch the definition of a table like its column’s names with their data types,default values ,allow nulls fields and if there r more than one indexes on that table ,they all should also be fetched on a datagrid at front end ?
please give me a proper solution……if possible. I will be grateful to u…….
Thanks Again,
very usefull materials thanks for providing.
In which scenario’s we go for clusterd and non-clusterd indexs
Thanks-a-lot! My search ends here!