SQL Server Stored Procedures Sample Code

------------------------------------------------------------
CREATE PROCEDURE GetCompleteEmailDirectory AS
SELECT * FROM Students
GO

------------------------------------------------------------

CREATE PROCEDURE .GetMatchingEmailEntries(@StuName nchar) AS
SELECT * FROM Students WHERE StudentName=@StuName
GO

------------------------------------------------------------

copyright Brian J. Reithel, PhD, CDP 2005