|
 |
 |
SQL Basics :: Select Statement
,
1/21/2002
,
The most basic SQL statement that you can use is the Select statement. This statement will allow you to get a set of records from a database.
SQL Basics :: Conditional Selection and Where Clause
,
1/21/2002
,
The SELECT Statement works good, but what if you want to select certian records, The Where Clause enables you to select certain records depending on the parameters you define.
SQL Basics :: Insert Statement
,
1/21/2002
,
Now that you know how to select records out of a database, you should also know how to insert records in to one.
SQL Basics :: Update Statement
,
1/21/2002
,
The Update Statement is very useful, you can use The Update Statement to update records on your database.
SQL Basics :: Delete Statement
,
1/21/2002
,
since you know how to select, insert, and Update your database, its time to know who can you delete certain records too.
SQL Basics :: Joins Simplified
,
1/21/2002
,
The power of the select statement is realized in the Join. With the JOINS you can select records from two tables and return them all as one set of data.
SQL Basics :: And, Or and Order By
,
1/21/2002
,
To add two parameter to any of the SQL Statements, you would use And, Or. You also can order your recordset by using the Order By.
SQL Basics :: Insert records in to a database
,
1/21/2002
,
Here real examples using the Insert Statement to insert some data to a table.
SQL Basics :: Update records in a database
,
1/21/2002
,
Here real examples using the Update Statement to update some data on a table.
|
 |
 |
|
|