SQL Server stored procedure with parameters

Question

I'm brand new to SQL Server and trying to write a stored procedure that updates a recordset with the current date/time at the time the stored procedure is called. My code keeps reporting an error near the =. The parameter @SentFax is the PK of the record needing to be updated, any ideas why this doesn't work?

CREATE PROCEDURE FaxMailerSent 
-- Add the parameters for the stored procedure here
@SentFax int = 0, 
  = 
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
UPDATE FaxMailer 
    SET Done = GetDate()
        WHERE [Fax_ID] = @SentFax; 
END
GO

Take out the comma after the @SentFax int = 0 and the ` = ` on the next line (before AS). — Chris Shaffer
– Chris Shaffer, Commented Jun 9, 2013 at 19:07
@ChrisShaffer your the best, thanks! put it in an answer so I can give you the credit for it — HashHazard
– HashHazard, Commented Jun 9, 2013 at 19:09

Dennis Traub · Accepted Answer · 2013-06-09 19:08:29Z

1

Remove the ,after @SentFax int = 0 and the = between @SentFax int = 0 and AS.

The following should work as expected:

CREATE PROCEDURE FaxMailerSent 
    @SentFax int = 0
AS
BEGIN
SET NOCOUNT ON;

UPDATE FaxMailer 
    SET Done = GetDate()
        WHERE [Fax_ID] = @SentFax; 
END
GO

answered Jun 9, 2013 at 19:08

Dennis Traub

51.9k7 gold badges100 silver badges113 bronze badges

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

Comments

Santosh · Accepted Answer · 2013-06-09 19:10:51Z

0

Try below

CREATE PROCEDURE FaxMailerSent 
-- Add the parameters for the stored procedure here
@SentFax int = 0
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
UPDATE FaxMailer 
    SET Done = GetDate()
        WHERE [Fax_ID] = @SentFax; 
END
GO

answered Jun 9, 2013 at 19:10

Santosh

12.4k4 gold badges43 silver badges74 bronze badges

Collectives™ on Stack Overflow

SQL Server stored procedure with parameters

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related