Error when trying to create stored procedure

Question

I am trying to create a procedure in my SQL Server Management Studio.

I wrote this code:

CREATE PROCEDURE [dbo].[InsertBookDetails_Sp]
    @BookName  VARCHAR(100),
    @Author    VARCHAR(100),
    @Publisher VARCHAR(100),
    @Price     DECIMAL(18,2),
    @BookPic   VARBINARY(MAX) = NULL, 
AS
BEGIN 
    SET NOCOUNT ON;

    INSERT INTO BookDetails(BookName, Author, Publisher, Price, BookPic)
    VALUES (@BookName, @Author, @Publisher, @Price, @BookPic)
END

but it shows error

Incorrect syntax near 'As'.
Invalid ObjectName BookDetails
Invalid Column name BookName
Invalid Column name Author
Invalid Column name Publisher
Invalid Column name Price
Invalid Column name BookPic

How to solve this error?

Remove the comma before the AS.

NineBerry
– NineBerry

2018-07-04 22:32:33 +00:00
Commented Jul 4, 2018 at 22:32 — NineBerry
– NineBerry, Commented Jul 4, 2018 at 22:32

Raju Joseph · Accepted Answer · 2018-07-04 22:38:17Z

1

The last parameter should not have ",". Remove the extra "," and try:

CREATE PROCEDURE [dbo].[InsertBookDetails_Sp]
@BookName VARCHAR(100),
@Author VARCHAR(100),
@Publisher VARCHAR(100),
@Price DECIMAL(18, 2),
@BookPic VARBINARY(MAX) = NULL

AS BEGIN SET NOCOUNT ON; INSERT INTO BookDetails (BookName, Author, Publisher, Price, BookPic) VALUES (@BookName, @Author, @Publisher, @Price, @BookPic); END

answered Jul 4, 2018 at 22:38

Raju Joseph

5532 gold badges7 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error when trying to create stored procedure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related