A Quick Way to Visualize
SQL Statements in SQL Server 2005 Management Studio
Provided by: FMS Development Team
You can quickly visualize complex queries by simply
selecting the complex query text in SQL Server 2005 Management Studio, then
right clicking on the selection and picking “Design Query in Editor…”
The following example uses the Northwind sample
database to demonstrate the tip.
1
Connect to the database where the query will run and select the text
of the query in the query window.

2
Right click and choose “Design Query in Editor”

3
Visualize and design the query

4
You can start a new query by not selecting any text in the query
window but just right clicking and choosing “Design Query in Editor”
Return to the tips page
|