How do I access the SQL Server 2005 Management Studio Query Designer?
• Open SQL Server 2005 Management Studio • Click the ‘New Query’ button from the standard tool bar or press Ctrl+Shift+Q • On the SQL Editor tool bar, select the needed database from the database drop down list in our case ‘BaltSSUG’ • On the SQL Editor tool bar, click on the ‘Design Query in Editor’ button • Follow the steps in next section to select the needed tables, then build and test the query What are the capabilities with the SQL Server 2005 Management Studio Query Designer? • Select the user defined tables needed for the query. *** NOTE *** – System tables are not available as options in this tool. • Once the tables load in the top of the interface, arrange the tables so they make sense. Next select the columns that you want to use in the query as well as the alias, sort type, sort order, etc. Notice how the T-SQL for the SELECT statement is being created and updated as columns are chosen. Finally, press the ‘OK’ button and the query will then load into the original query wind
