ALTER PROCEDURE [dbo].[GetAllCategories] (@Name VARCHAR) AS SELECT * FROM category WHERE Name = @Name