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.

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

	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.