Someone

--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