Query Type

There are three query types. Each is defined below.

Select

A select query is used to return rows from a table or group of tables in the selected database.

Update

An update query is used to add, update, or delete rows from a table or group of tables in the selected database.

Stored Procedure

A stored procedure query is used to pass values as input parameters to a stored procedure and to save any output or return parameter values to defined fields.