|
|
|
|
|
SQL In Simple English - Part II.
|
|
This is the second article in this series. If you liked the first one, you will definitely like this one too. This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.
|
|
|
|
|
|
|
SQL In Simple English - Part 1.
|
|
Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more..
|
|
|
|
|
|
|
Turn foreign keys into list boxes
|
|
CoverYourASP's original database administration tool didn't look for foreign keys, and just displayed a confusing list of primary key values. Now, it's been improved with automatically generated list boxes...
|
|
|
|
|
|
|
|
Search your site
|
|
Learn how to add the ability to search through pages on your site by storing keywords in a database table. One server side include containing one function is all you need.
|
|
|
|
|
|
|
Running Stored Queries in Access Database
|
|
Explains everything in detail you'll ever need to know about creating Stored Queries in Access Database and then calling from within ASP. Select, Update, Insert and Delete Stored Procedures are described. Sample code and database available for download.
|
|
|
|
|
|