How to add a derived table to a query in the Diagram Pane in SQL server

When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to add a derived table to a query, they should follow the next steps:

C# in Depth, 3rd EditionManaged Windows VPS Hosting

1. Open an existing query or create a new query.

2. Right-click the Diagram Pane and choose Add New Derived Table.

A new table with the name derivedtbl_N is added, and the derived table’s SELECT statement is added to the query’s FROM clause.