Stored Procedure: Simple Select

/* SELECTS * FROM COMPANIES VIA COMPANY NAME */

CREATE PROCEDURE [SEARCH_COMPANYNAME]
@strCompanyName nvarchar(50)

AS
SELECT * FROM COMPANIES WHERE COMPANYNAME =@strCompanyName
GO