When developers want to use a column in a query they must add it to the query. They can add a column a column to display it in query output, to use it for sorting, to search the contents of the column, or to summarize its contents. Developers can decide which of the columns they use in the query are included in the results pane when the query is run. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to add all columns for one table or table-valued object, they should do the next:

– In the Diagram Pane, select the check box next to *(All Columns).