Working with Different Query Types

Query Builder for SQL Server gives you an ability to simplify your work with different types of SQL queries. Using these types, you can manipulate or control your data to your profit.

Query Types

The current type is specified on the label in the left upper part of any query document. To change it, use the Change type list on the toolbar or the Change type item in the shortcut menu of the document.

Name Description
SELECT SELECT Use this type to create queries with the SELECT operator.
INSERT RESULTS INSERT RESULTS Use this query type to create queries with the INSERT INTO operator. Click the ellipsis button on the label to select the needed table or click the name of the selected table on the label to change it. Specify the needed values and conditions on the tabs below the diagram.
INSERT VALUES INSERT VALUES Use this query type to create queries with the INSERT INTO operator. Click the ellipsis button on the label to select the needed table or click the name of the selected table on the label to change it. Specify the name and value you want to insert in the Insert tab.
UPDATE UPDATE Use this query type to create queries with the UPDATE operator. Click the ellipsis button on the label to select the needed table or click the name of the selected table on the label to change it. Specify the needed values on the tabs below the diagram.
DELETE DELETE Use this query type to delete records from the selected table. Click the ellipsis button on the label to select the needed table or click the name of the selected table on the label to change it. Specify the needed condition on the Where tab under the diagram.

Note
You can add only one row to a table in one query.