Re: Is SQL procedural or non-procedural?

kumar.vaibhav.jain_at_gmail.com wrote:

> Hi,
>
> I am confused on this issue that wether SQL is procedural or non
> procedural. What are your views on this issue?
>
>
> Thanks,
>
> VJ

Most if not all actual SQL implementations out there provide a procedural language for writing routines on the server. The non-procedural DML commands SELECT and friends can be embedded into the routines.

These languages have everything you would expect: IF..THEN/ELSE, DO WHILE and so forth.

These procedural languages are what extends databases so far beyond the passive role they are restricted to otherwise.

-- 
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)