query
Home > SQL Server Definitions - Query
SearchSQLServer.com Definitions (Powered by WhatIs.com)
EMAIL THIS
LOOK UP TECH TERMS Powered by: WhatIs.com
Search listings for thousands of IT terms:
Browse tech terms alphabetically:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

query



Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   

DEFINITION - In general, a query (noun) is a question, often required to be expressed in a formal way. The word derives from the Latin quaere (the imperative form of quaerere, meaning to ask or seek). In computers, what a user of a search engine or database enters is sometimes called the query. To query (verb) means to submit a query (noun).

A database query can be either a select query or an action query. A select query is simply a data retrieval query. An action query can ask for additional operations on the data, such as insertion, updating, or deletion.

Languages used to interact with databases are called query languages, of which the Structured Query Language (SQL) is the well-known standard.

Getting started with queries
To explore how queries are used in the enterprise, here are some additional resources:
ricks to increase SQL Server query performance: Increase query performance in SQL Server by having a few tricks up your sleeve. Also, find out a stored procedure method that improves query response time.
FAQ: SQL Server query errors and explanations: Queries in SQL Server have many daunting components. Learn how to fix code errors, speed up queries, show the query navigation path and more.
SQL Server query design: 10 mistakes to avoid: SQL Server queries should guide you toward trouble-free data retrieval. This list of query design mistakes includes the misuse of SELECT statements.

LAST UPDATED: 27 Oct 2008

Read more about query:
- Netscape offers an Introduction to Queries .
- This Introduction to Structured Query Language shows how to build a query.
- SearchVB.com, a portal for Visual Basic developers, includes a collection of links about VB database queries.


Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.com


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Avoid cursors in SQL Server with these methods to loop over records
Avoid using a SQL Server cursor for looping over records row by row. Alternate methods use temp tables instead of SQL cursors that slow down...
Implementing security audit in SQL Server 2008
The SQL Server 2008 security audit eases the task of creating audits to track SQL database instance use. Learn how to create an audit in SQL Server...
New datetime data types in SQL Server 2008 offer flexibility
New datetime data types in SQL Server 2008 offer advanced options for flexibility. Learn how to use DATE, TIME, DATETIME2 and DATETIMEOFFSET in SQL...

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
ACID  (SearchSQLServer.com)
commit  (SearchSQLServer.com)




query Solutions - SQL White Paper Library
HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts