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 all tables and table-structured objects, they should follow the next steps:
1. Make sure no join lines in the Table Operations Pane are selected.
2. Right-click in the empty space of the Design window and choose Properties from the shortcut menu.
3. In the Properties window click Output all columns and choose Yes or No from the dropdown list.