Working with Different Query Types

Last modified: October 23, 2019

dbForge Fusion 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 on the pop-up menu of the document.

Name	Description
SELECT	Use this type to create queries with the SELECT operator.
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	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	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	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.