1. From the Programs

    

 What are the differences between FoxPro and MS SQL Server?

The MySQL® database is the most popular world's open source database because of its consistent fast performance, high reliability and ease of use. You can find most of Web developers dealing with Mysql And PHP based Web developments.This database is used with many popular web sites and most of sites are now reffering this database.

DCL language is used to control access to data in a database.This language defines the access permissions for users and groups on the pieces of data in database.E.g We use commands to provide permissions for individual user to make SELECT statements for data table.

Examples of DCL commands include:

•     GRANT to allow specified users to perform specified tasks.
•     REVOKE to cancel previously granted or denied permissions.

The following privileges can be GRANTED TO or REVOKED FROM a user or role:

DML is used by computer programs database users to retrieve, insert, delete and update data in a database.Currently the most popular data manipulation language is that of SQL, which is used to retrieve and manipulate data in a Relational database.

Basic Data operations are:-

1. Select
2. Insert
3. Update
4. Delete

A Data Definition Language (DDL) is a computer language for defining data structures.In SQL, DDL contains commands for defining structure of data,altering and deleting structure of data.

1. Used to specify a database scheme as a set of definitions expressed in a DDL
2. DDL statements are compiled, resulting in a set of tables stored in a special file called a data dictionary or data directory.

    

    

SQL query language is used to retrieve the information stored in the database.In SQL a query has the following (simplified) form.brackets [ ] are optional):

Syntax:-

select [distinct] <column(s)>
from <table>
[ where <condition> ]
[ order by <column(s) [asc|desc]> ]

EXAMPLES:-

SQL>select * from USERS;

SQL>select name,email,phone from USERS;

SQL is a standard language for storing, manipulating, and retriving data stored in relational databases using a predefined language syntax and rules.SQL is widely used database language and provides  data manipulation (store, retrieve, update, delete) and database creation) with DataBase management Systems.

There are many types of DBMS(Database management Systems) available in market E.g: MS SQL Server, Microsoft Access, MSDE, Oracle, DB2, Sybase, MySQL, Postgres and Informix and they use SQL as standard database language.

SELECt command Retrieves data from one or more tables. When you use SQL SELECT to create a query, Visual FoxPro parses the query and retrieves the specified data from the tables. You can create a SQL SELECT query from the Command window, in a Visual FoxPro program, or using the Query Designer. You must read the Considerations for SQL SELECT Statements help topic for more information on using SQL SELECT.

SYNTAX:-

SQL is a language used for accessing and manipulating databases by issuing queries(commands or request) for data.

basic operations for data base are INSERT,UPDATE,DELETE and SQL provide commands for each of these operations but SQL also provide others type of operations of DATABASES.

SQL can be divided into two parts:

1. Data Manipulation Language (DML)
2. Data Definition Language (DDL).