Difference between programming language and query language?

Answer 1

In a programming language (such as Basic, C, COBOL, FORTRAN, and so on), you write lines of code that perform one operation after another until the program completes its tasks. The program may execute its lines of code in a linear sequence or loop to repeat some steps or branch to skip others. In any case, when writing a program in a procedural language, the programmer specifies what is to be done and how to do it.

SQL, on the other hand, is a query language in that you tell SQL what you want to do without specifying exactly how to accomplish the task. The DBMS decides the best way to perform the job.

Suppose, for example, that you have a CUSTOMER table, and you want a list of customers that owe you more than $1,000.00. You could tell the DBMS to generate the report with this SQL statement:

SELECT

NAME, ADDRESS, CITY, STATE, ZIP, PHONE_NUMBER,

BALANCE_DUE

FROM

CUSTOMER

WHERE

BALANCE_DUE > 1000.00

If writing a procedural program, you would have to write the control loop that reads each row (record) in the table, decides whether to print the values in the columns (fields), and moves on to the next row until it reaches the end of the table. In SQL, you specify only the data you want to see. The DBMS then examines the database and decides how best to fulfill your request.

Answer 2

Technology is developed for a particular purpose..For example, For development of web related applications, you have technology called "ASP.NET". For development of DataBase related applications, we have another technology called "ADO.NET" . But the Technology, doesn't offer any specific rules for writing the programs. But it offers some library. That's why, a technology cannot be implemented individually. It Requires a language for the rules to write the programs.

Answer 3

In a programming language (such as Basic, C, COBOL, FORTRAN, and

so on), you write lines of code that perform one operation after

another until the program completes its tasks. The program may

execute its lines of code in a linear sequence or loop to repeat

some steps or branch to skip others. In any case, when writing a

program in a procedural language, the programmer specifies what is

to be done and how to do it.

SQL, on the other hand, is a query language in that you tell SQL

what you want to do without specifying exactly how to accomplish

the task. The DBMS decides the best way to perform the job.

Suppose, for example, that you have a CUSTOMER table, and you

want a list of customers that owe you more than $1,000.00. You

could tell the DBMS to generate the report with this SQL

statement:

SELECT

NAME, ADDRESS, CITY, STATE, ZIP, PHONE_NUMBER,

BALANCE_DUE

FROM

CUSTOMER

WHERE

BALANCE_DUE > 1000.00

If writing a procedural program, you would have to write the

control loop that reads each row (record) in the table, decides

whether to print the values in the columns (fields), and moves on

to the next row until it reaches the end of the table. In SQL, you

specify only the data you want to see. The DBMS then examines the

database and decides how best to fulfill your request.