DTS Query Designer
Data Transformation Services (DTS) Query Designer uses a graphical user interface for creating SQL queries. Use DTS Query Designer to:
- Work visually or with SQL commands.
DTS Query Designer includes graphical panes that display your query visually and a text pane that displays the SQL text of your query. You can work in either the graphical or text panes. DTS Query Designer synchronizes the views so they are always current.
- Join related tables.
If you add more than one table to your query, DTS Query Designer automatically determines how the tables are related and constructs the appropriate join command.
- Query or update databases.
You can use DTS Query Designer to return data using Transact-SQL SELECT statements and to create queries that update, add, or delete records in a database.
- View and edit results immediately.
You can execute your query and work with a record set in a grid that allows you to scroll through and edit records in the database.