Working of SQL,Learn how sql commands are work
SQL stands for structured query language.it 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
you had just specified the SELECT statement not the actual working functionality of the SQL.