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:
All ASP pages in this chapter use following