Stored procedures can be created through a database management GUI (SQL Server example), or through a SQL statement as follows:
-- Define a name and parameters
CREATE PROCEDURE Northwind.getEmployee
@LastName nvarchar(50),
@FirstName nvarchar(50)
AS
-- Define the query to be...
