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
Working with sparse columns in SQL Server 2008
Sparse columns can provide significant storage benefits to those working with SQL Server 2008. Learn the proper way to implement sparse columns,...
Determining the source of full transaction logs in SQL Server
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
New GROUP BY option provides better data control in SQL Server 2008
GROUPING SETS in the GROUP BY clause trumps the ROLLUP and CUBE options by providing a more efficient and specific data aggregator, as well as more...

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 technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




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