--ALTER PROCEDURE [dbo].[GetAllCategories] --(@Name VARCHAR) --AS --SELECT * --FROM category --WHERE Name = @Name ALTER procedure dbo.GetAllCategories @name varchar AS begin AS SELECT * FROM category WHERE Name = @Name end GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO