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.
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.