pietlinden (9/20/2013)

---

No. I was leaving out a bunch of stuff. It was the bare bones of a stored procedure. One of the differences between a view and a stored procedure is that you cannot pass parameters to a view, but you can to a stored procedure.

For example

CREATE VIEW vw_allFemales AS

SELECT FirstName, LastName

FROM Person

WHERE Gender = 'F';

Stored procedure:

CREATE PROC usp_EmployeesByGender

@Gender CHAR

AS

SELECT FirstName, LastName

FROM Person

WHERE Gender = @Gender;