|
Incorporating SQL Server 7.0/2000 Databases into your ASP Pages
|
Other links at ASP > Tutorials > Database-related |
| 1. |
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.
|
| 2. |
Using SUM Function in An SQL Statement
|
|
|
Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.
|
| 3. |
An Easy Way Delete A Record
|
|
|
Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.
|
| 4. |
Using SQL-DMO To Backup and Verify a Database
|
|
|
This article shows you how to use SQL-DMO to create an Active Server Pages application to backup and verify a SQL Server database. The SQL Distributed Management Objects (SQL-DMO) extend the functionality of SQL Server by providing developers a way to execute common tasks.
|
| 5. |
Search db by Field
|
|
|
Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.
|
|
|
