stored procedure con ASP

[eurojames]

HOLA DE NUEVO LO QUE TENGO SON 4 STORED PROCEDURE EN UNA BASE DE DATOS DE SQL SERVER 2000, TE PASO UN EJEMPLO DE CADA TIPO:

PARA INSERT:

Create Procedure sp_InsertCustomer(
@first_name varchar(50),@middle_name varchar(50) = NULL,
@last_name varchar(50),@city varchar(50),@state varchar(50),
@country varchar(50), @customer_id int OUTPUT)
AS
BEGIN
INSERT INTO customer(first_name, middle_name, last_name, city, state,country)
VALUES(@first_name, @middle_name, @last_name,@city, @state, @country)
SELECT @customer_id = @@IDENTITY
END

PARA UPDATE:

Create Procedure sp_UpdateCustomer(@customer_id int,
@first_name varchar(50),@middle_name varchar(50) = NULL,
@last_name varchar(50),@city varchar(50), @state varchar(50),
@country varchar(50))
AS
BEGIN
UPDATE customer(set first_name = @first_name, set middle_name = @middle_name, set last_name = @last_name,
set city = @city, set state = @state, set country = @country)
WHERE customer_id = @customer_id
END

PARA DELETE:
Create Procedure sp_DeleteCustomer(
@customer_id int)
AS
BEGIN
DELETE FROM customer WHERE customer_id = @customer_id)
END


PARA SELECT :

Create Procedure sp_GetCustomer(
@customer_id int)
AS
BEGIN
SELECT * FROM customer WHERE customer_id = @customer_id)
END



ESTOS SON LOS CUATROS TIPOS DE SP QUE QUIERO USAR EN ASP, ESPERO QUE PUEDA SER DE AYUDA

GRACIAS