0
The results are not saved, but the query can be. If the query has been saved, then it can be run at any time to retrieve the data. So it is not necessary to save the data itself. You can write queries that will select data and write it to a new table, in which case the results are being saved.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is back-end database testing?
It is a types of testing in which one will perform write query using sql statement whatever data you fill that data should be saved in back end . for eaxmple my sql,sqlserver, oracle like that so on.
Where can I download OCR Software for free?
You can check out freewarezoom.com. You can also try www.brothersoft.com. If you do a query you should get a few results. Here there are a URL (http://www.topocr.com/topocr.html) or a complete list here ( http://www.thefreecountry.com/utilities/ocr.shtml)
What does the mean in Microsoft Access?
The * symbol is a universal wildcard symbol. In the Access Query By Example Design Pane, the * represents all fields in the table or query.
What does QBE stand for?
QBE stands for Query by Example.
DBA need query optimization?
Data is inserted into a database. Users need to get information from the database. These requests are called "queries". Data is continually being inserted into the tables in the database. There is a utility called "update statistics" which gathers information from the table and feeds is to the "query optimizer". The query optimizer, based on information gathered from update statistics, chooses the most efficient path to gather the data for the user and return the results as quickly as possible. How often statistics must be updated is completely dependent upon the frequency and quantity of updates/inserts/deletes into the table. If the table is static (unchanged), then once update stats is ran, there is no need to run it again.
To view results in a saved query right click the query in the navigation pane and click?
open on the shorcut menu,
How do you view the results of a saved query in Microsoft Access?
Run the query. If in Design view you can do that by clicking on the red exclamation mark. If you go to the window and open the query directly, it will run.
What is ment by query?
Query is an instruction given to Database engine to retrieve the results. Example: Select EmployeeName From tblEmployees Where EmployeeID = 123; This is a sample query to retrieve the Name of a particular employee from the set of records saved already.
What type of query allows you to quantify the results?
Top-values query
What are the uses of a Query?
In MS Access, a Query is a saved search, which can be used in reports, etc.
Each time you open a saved quer Access the query again and displays the results based on the data stored in the associated tables thus thus the results always reflect the latest information in?
database
A query that that retrieves records based on the results of another query is referred to as a?
This is called a correlated sub-query.
What is a(n) is a saved object within the datasheet.?
query
When queries are saved and run again at a later date one advantage is that the query uses the most information.?
current
What is the difference between QBE and SQL?
Query by Example (QBE) is a database query language for relational databases. A QBE parser parses the search query and looks for the keywords. A more formal query string, in languages such as SQL, is then generated, which is finally executed. However, when compared with a formal query, the results in the QBE system will be more variable.SQL (Structured Query Language) SQL is a set-based, declarative query language, not an imperative language such as C or BASIC. However, there are extensions to Standard SQL which add procedural programming language functionality, such as control-of-flow constructs
Use the word query in a sentence?
I'm hard-pressed to elucidate an answer to your query. Every query has more than one answer. My results of my research do not definitively resolve your query. Is that the finest query you could devise on the subject?
How can you sort the results from an sql statement?
You can sort the results of a query by using the order by clause. Ex: Select * from tbl_employee order by emp_num The above query would sort the results by the employee number and display them. The default sort is ascending order. Ex: Select * from tbl_employee order by emp_num desc The above query would sort the results by descending order of employee number and display them.
