With the help of an example, briefly state the meaning of parameter queries.
With the help of an example, briefly state the meaning of parameter queries.
A Parameter Query is a query where for selecting a set of records, the user is asked to enter parameters or criteria through an input box. A Parameter Query is useful when the same query is to be repeated with different criteria.
In short, it implies the execution of same set of queries with different requirements.
For example, the same set of queries is required for different accounts code, while extracting the information to prepare ledger.
Let us consider the given below SQL statement.
PARAMETERS Accounts Name Text (145)
SELECT Name
FROM Accounts
WHERE Code = Account No
In the above query, PARAMETERS clause is used to represent the variable Account No. This SQL statement requires the user to provide the different values of Account No.
A Parameter Query is a query where for selecting a set of records, the user is asked to enter parameters or criteria through an input box. A Parameter Query is useful when the same query is to be repeated with different criteria.
In short, it implies the execution of same set of queries with different requirements.
For example, the same set of queries is required for different accounts code, while extracting the information to prepare ledger.
Let us consider the given below SQL statement.
PARAMETERS Accounts Name Text (145)
SELECT Name
FROM Accounts
WHERE Code = Account No
In the above query, PARAMETERS clause is used to represent the variable Account No. This SQL statement requires the user to provide the different values of Account No.
