Enter the code for each of the following examples into your IDE and run them against the AdventureWorks database. Screen captures your results and pastes them into a text document that you upload to this assignment.

1. Creating a simple Transact-SQL procedure (using a view with no parameters)

USE AdventureWorks;

GO

CREATE PROC dbo.Headcounts AS

BEGIN

SET NOCOUNT ON;

SELECT JobTitle, Status, Headcounts FROM dbo.vwStatus

ORDER BY Headcounts desc

END

GO