Creating a Query
Creating a Query
To create a new query
In the SQL Server Enterprise Manager, right-click any table or view that will be included in the query.
On the shortcut menu, point to Open Table and choose Query, or point to Open View and choose Query.
The Query Designer appears with the table or view already present on the Diagram Pane.