How to work with different query types
dbForge Studio 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 |
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.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?