DuNiaMuu.. DuNiakuu..

Create an ASP SQL Stored Procedure

Stored Procedures are very powerful database tools. They are essentially mini-programs and using SQL you can achieve many of the programmatic tricks you might use in an ASP page, including loops, if else statements and so on.

The useful thing about stored procedures is that they separate out the database activity from the displaying. This keeps your ASP pages very simple and makes maintenance a lot easier.

Here I'll introduce you to the basics of using a stored procedure and passing a parameter to it.

download article procedure