Stored Procedures with ASP

This short article demonstrates how to use stored procedures with ASP. First we need the stored procedure.
Here is a sample one:

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE spGetCategoriesByProject
(
	@projID int,
	@objID int
)

AS

SELECT DISTINCT
	cat.categoryID, categoryName
FROM
	tblCategory as cat
INNER JOIN
	tblObjectCategory AS objCat
ON
	objCat.projID = cat.projID
INNER JOIN
	tblObjectType AS obj
ON
	objCat.objectTypeID = obj.objectTypeID
INNER JOIN
	tblObjectCategory
ON
	objCat.categoryID = cat.categoryID
WHERE
	objCat.objectTypeID = @objID
AND
	cat.projID = @projID
ORDER BY
	cat.categoryName

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Don't worry about what the procedure is actually doing, just note that it takes 2 parameters:
1) @projID
2) @objID

Next >>