Incorrect syntax near the keyword 'Values'

_{Thursday, November 6, 2014 5:36 PM}

Hi all I was wondering if you could help I keep getting this error when I try to build this stored procedure in sql 2008

CREATE PROCEDURE dbo.TutorialAddHeadline
    @title varchar(100), @content varchar(MAX), @publisher varchar(50), @linkurl varchar(255)
AS
    BEGIN
    DECLARE @hash binary(16);
    SET @hash = dbo.TutorialHash(@title, @content);
    
VALUES(@publisher, @title, @content, @linkurl, @hash);
END

thanks

_{Thursday, November 6, 2014 5:38 PM ✅Answered}

Try:

INSERT YOURTABLE (YOUR_COLUMN_LIST)

VALUES....

Kalman Toth Database & OLAP Architect SQL Server 2014 Database Design
New Book / Kindle: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014

_{Thursday, November 6, 2014 6:01 PM}

VALUES(@publisher, @title, @content, @linkurl, @hash);

What do you want to achieve with this code line? Return the values or insert them into a table or ... ?

Olaf Helper

[ Blog] [ Xing] [ MVP]