Cindy
asked on
Stored Procedure
I need to update this Stored Procedure by adding a row. Please Advise
I have another table called the Item's Table with Item_ID, Item_description, Item_Price. I need to create a stored procedure that will add additional item row? I attempted to creat the procedure and received number error messages
Here is what I created: When I execute I receive error message: Msg 102, Level 15, State 1, Procedure ADD_ITEM, Line 4 Incorrect syntax near 'NUMERIC'.
What am I doing wrong? Thanks
CREATE PROCEDURE ADD_ITEM -- Create a new item
@item_id_arg NUMERIC, -- This parameter is the new item ID.
@item_description_arg VARCHAR(30), -- This parameter is the item description.
@item_price NUMERIC -- This parameter is the item price.
AS -- This "AS" is required by the syntax of stored procedures.
BEGIN
-- Insert the new customer with the parameters given, and a 0 balance.
INSERT INTO item (item_ID,item_description, item_price)
VALUES(@item_id_arg,@item_ descriptio n_arg,@ite m_price_ar g,0);
END;
I changed the arugment '@item_price NUMERIC' to '@item_price_arg NUMERIC' and remove the 0 on the INSERT statement.
I am still receiving INcorrect syntax error.
I have another table called the Item's Table with Item_ID, Item_description, Item_Price. I need to create a stored procedure that will add additional item row? I attempted to creat the procedure and received number error messages
Here is what I created: When I execute I receive error message: Msg 102, Level 15, State 1, Procedure ADD_ITEM, Line 4 Incorrect syntax near 'NUMERIC'.
What am I doing wrong? Thanks
CREATE PROCEDURE ADD_ITEM -- Create a new item
@item_id_arg NUMERIC, -- This parameter is the new item ID.
@item_description_arg VARCHAR(30), -- This parameter is the item description.
@item_price NUMERIC -- This parameter is the item price.
AS -- This "AS" is required by the syntax of stored procedures.
BEGIN
-- Insert the new customer with the parameters given, and a 0 balance.
INSERT INTO item (item_ID,item_description,
VALUES(@item_id_arg,@item_
END;
I changed the arugment '@item_price NUMERIC' to '@item_price_arg NUMERIC' and remove the 0 on the INSERT statement.
I am still receiving INcorrect syntax error.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.