Creating and then executing Stored Procedures

[Rexolio]

Hi...

I'm TRYING to learn how to create a Stored Procedure in SQL for adding new records to a table and then creating an ASP that will collect data from a user via a form and then add it to the SQL table via the Stored Procedure.

Can anyone provide me with some sample code for one of the 2 or both? I'm using my books as a go-by, but still having trouble.

Thanks,
Rexolio

 

[durug]

the table will look like this:
firstname char(30)
email char(30)
so here is the SP:
CREATE PROCEDURE [sp_insertvalues]
(
@firstname char(30),
@email char(30)
)
AS
Begin
insert into tablename values (@firstname,@email)
END

and for the asp code you should check
thread333-80293 or
thread333-75792

Hope it helps,
Durug