CREATE PROCEDURE [dbo].[supplier]

INSERT INTO supplier
(supplier_id, supplier_name)
VALUES
(24553, 'IBM');

Msg 156, Level 15, State 1, Procedure supplier, Line 4
Incorrect syntax near the keyword 'INSERT'.

quote:

---

Originally posted by asp__developer

I am trying to create a new stored procedure but getting error:

My SP

CREATE PROCEDURE [dbo].[supplier]
AS
INSERT INTO supplier
(supplier_id, supplier_name)
VALUES
(24553, 'IBM');

Error

Msg 156, Level 15, State 1, Procedure supplier, Line 4
Incorrect syntax near the keyword 'INSERT'.

---