Question
With the help of an example, briefly state the meaning of parameter queries.
✓
Answer
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 = AccountNo
In the above query, PARAMETERS clause is used to represent the variable AccountNo. This SQL statement requires the user to provide the different values of Account No.
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 = AccountNo
In the above query, PARAMETERS clause is used to represent the variable AccountNo. This SQL statement requires the user to provide the different values of Account No.
Need a full question paper?
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.
Explore more
Similar questions
The following are the extracts from the trial balance of M/s Bhola & Sons as on March 31, 2017
Closing Stock as on date was valued at ₹ 3,00,000.
You are required to record the necessary journal entries and show how the above items will appear in the trading and profit and loss account and balance sheet of M/s Bhola & Sons.
Closing Stock as on date was valued at ₹ 3,00,000.
You are required to record the necessary journal entries and show how the above items will appear in the trading and profit and loss account and balance sheet of M/s Bhola & Sons.
What do you understand by saving a report as snapshot?
Give any three advantages of Single Entry System of Accounting.
What menu option is available in Gateway of Tally Screen?
Explain the meaning of Imprest System of Petty Cash Book.
From the following information, calculate Total Sales made during the period:
| ₹ | |
| Debtors as on 1st April, 2017 | 20,400 |
| Cash received from debtors during the year (as per Cash Book) | 60,800 |
| Returns Inward | 5,400 |
| Bad Debts | 2,400 |
| Debtors as on 31st March, 2018 | 27,600 |
| Cash Sales (as per Cash Book) | 56,800 |
What are the advantages of Word Processor?
Which of the following errors will affect the Trial Balance?
- The total of the Sales Book has not been posted to the Sales Account.
- ₹ 1,000 paid as installation charges of a new machine has been debited to Repairs Account.
- Goods costing ₹ 4,000 taken by the proprietor for personal use have been debited to Debtors’ Account.
- ₹ 1,000 paid for repairs to building have been debited to Building Account.
What is the purpose of preparing trading and profit and loss account?
Following balances appear in the Trial Balance of a firm as on $31^{st}$ March, $2019$:
Prepare Trading Account of the firm.
→|
|
|
₹
|
|
Opening Stock:
|
Raw Material
|
80,000
|
|
|
Finished Goods
|
1,40,000
|
|
Purchases
|
|
3,60,000
|
|
Sales
|
|
7,00,000
|
|
Returns:
|
Purchases
|
10,000
|
|
|
Sales
|
6,000
|
|
Wages
|
|
1,30,000
|
|
Factory Expenses
|
|
90,000
|
|
Freight:
|
Inwards
|
20,000
|
|
|
Outwards
|
30,000
|
|
At the end of the accounting period, stock was:
|
|
|
|
Raw Materials
|
|
70,000
|
|
Work-in-Process
|
|
20,000
|
|
Finished Goods
|
|
1,10,000
|