Transact-SQL and ASP

Here are 3 very simple ASP scripts for selecting, adding and deleting records from EmployeeFacts table. ASP pages are designed to call stored procedures and they never address database tables directly, in order to provide more security to the client-server interaction.

TSQL stored procedures:

Stored procedure that retrieves data from EmployeeFacts
Stored procedure that adds record to EmployeeFacts
Stored procedure that deletes records for given Employee Number

ASP Scripts:
Examples preview
ASP select page: source code
ASP add page: source code
ASP delete page: source code

All ASP pages in this chapter use following Connection String:
"Provider=SQLOLEDB.1;Password=george;Persist Security Info=True; User ID=george;Initial Catalog=colombo;Data Source=AMPER"
If you will try to convert the scripts for your own needs, you'll have to edit this string according to the settings of your environment.