Working of SQL,Learn how sql commands are work

SQL stands for structured query is pronounced sequel(like a movie sequel)SQL used to as a mean of communicating to the DBMS what you want to do.SQL commands consist of English like statement which are used to query,insert,update and delete data.both ASP and SQL are powerful tools for mining information,combining data from diffrent source,and developing web applications

SQL stands for structured query language.SQL allows you to manipulate databases through the internet .if you are using ASP,however SQL satements can supply significant and sophisticated method to get at the data.SQL language is a relational database language. SQL command are consist of english like statement which are used to query,insert,update and delete data
Commercial database management system allow SQL to be used in to distinct ways.

First Method

,SQL commands can be typed at the command line directly.

second method

This is called programmatic SQL.HERE,SQL statements are embeded in a host language such as COBOL or C.SQL needs a host language beacause SQL is not really a copmlete computer programming language as such.The basis of much of the work you do with SQL is the select statement.YOU can refine your search by using WHERE clause with the SELECT statement.

lets see a examples of SQL query

SELECT SQL Statement-SQL="SELECT p_name FROM Products"
The content of the p_name column in the Product table will be pulled when Query is executed


Guest Author: suppa12 Mar 2012

you had just specified the SELECT statement not the actual working functionality of the SQL.

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: