Next Chapter 86 THE SQL SERVER 2000
PROJECT SOURCE CODE
SPONSORED LINKS
THE SQL SERVER 2000
The SQL SERVER 2000 server is an object-relational database management system that provides an open, comprehensive, and integrated approach to information management.
STRUCTURED QUERY LANGUAGE (SQL)
SQL (pronounced SEQUEL) is the programming language that defines and manipulates the database. SQL databases are relational databases; this means simply that data is stored in a set of simple relations. A database can have one or more tables. Each table has columns and rows. A table that has an employee database, for example, might have a column called employee number and each row in that column would be an employee's employee number.
You can define and manipulate data in a table with SQL statements. You use data definition language (DDL) statements to set up the data. DDL statements include statements for creating and altering databases and tables.
You can update, delete, or retrieve data in a table with data manipulation language (DML). DML statements include statements to alter and fetch data. The most common SQL statement is the SELECT statement, which allows you to retrieve data from the database.
In addition to SQL statements, the SQL SERVER 2000 server has a procedural language called PL/SQL. PL/SQL enables programmers to program SQL statements. It allows you to control the flow of a SQL program, to use variables, and to write error-handling procedures.