by, 03-09-2012 at 07:21 PM (625 Views)
Databases are accessed by usage of a standard language SQL. It is used for the manipulation and also to access the data, in following.
- SQL Server
The SQL language consist of these language elements:
- Clauses: Clauses are considered to be the constituent components of queries and statements.
- Expressions: They can produce tabular data or scalar values which comprises of columns & rows.
- Predicates: conditions are specified which can be evaluated to SQL
- Queries: data is retrieved based on criteria.
- Statements:. Hold a permanent effect at data. It controls connections, transactions, program flow and sessions.