Re: SQL??????????

SQL stands for Structured Query Language. It was designed to easily manipulate data in Relational databases. At the heart of it, the langauge basically comprises of just 4 statements... SELECT, INSERT, DELETE and UPDATE. Whereas INSERT, DELETE and UPDATE allow the users to insert, delete and update data, SELECT allows users to read data. The beauty is that the user does not have to write the logic for how to read the data... just has to mention what data he/she wants to read and whatever the conditional clause is.

Access and other flat file dbs expect the users write the how logic.. for e.g., to compute the sum total of col A in table T for all rows in which col B is 0, one would have to write code to traverse thru all the rows and compute the sum if the condition is true. In SQL, one would write...
SELECT SUM(a)
FROM t
WHERE b = 0

Hope this helps.
-sm

On 13 Nov 1997 16:28:46 GMT, "Ronald Colijn" <Colijnen_at_worldonline.nl> wrote:

>Hello,
>
>I just wanted to ask if anyone can tell me what SQL means, and what you can
>do with it.
>I know my way arround MSAccess and is it something that you can compare
>with it?
>
>Thanks
>
>--
>Thanks Colijnen_at_worldonline.nl
>
>--
>In 1969 I gave up booze and women,
>it was the worst 20 minutes of my life.
Received on Thu Nov 13 1997 - 00:00:00 CST