Home > Enterprise >  Incorrect syntax near 'var_category_name'. Expecting VARIABLE
Incorrect syntax near 'var_category_name'. Expecting VARIABLE

Time:11-16

I am trying to write a script that creates and calls a stored procedure named spInsertNewCategory and getting this error on the following code:

CREATE PROCEDURE spInsertCategory(category_name VARCHAR(50))
BEGIN
INSERT INTO Categories
VALUES (@CategoryName);
END

enter image description here

  • Related