The Query Analyzer has many useful features, which I won't cover here in an attempt to focus on the basics. To find out what those features are, use the toolbar or press F1 to get the Transact-SQL ...

Management Studio includes the functions of SQL Server 2000 Enterprise Manager, Analysis Manager, and SQL Query Analyzer in one tool, along with the ability to write MDX, XMLA, and XML statements.