Problem with an Create Procedure or Insert Statment. Error Message: "error near @Parameter Name"

Question

CREATE PROCEDURE dbo.InsertInboxMessage
    @UserID uniqueIdentifier
    @Message nvarchar(Max)
AS 
   INSERT INTO Messages(UsersID, Messages)
   VALUES(@UserID, @Message) 

It tells me that I have an error near @Message and that I must declare the scalar @UserID.

How do I correct those errors?

Answer 1

You are missing a Comma after the first parameter declaration

CREATE PROCEDURE dbo.InsertInboxMessage
    @UserID uniqueIdentifier,   -- Comma goes here!
    @Message nvarchar(Max)
AS
   INSERT INTO Messages(UsersID, Messages)
   VALUES(@UserID, @Message)

References

• TSQL Create Procedure Syntax

Answer 2

You need a comma in between your variables.

CREATE PROCEDURE dbo.InsertInboxMessage

@UserID uniqueIdentifier,
@Message nvarchar(Max)
AS

INSERT INTO Messages(UsersID, Messages) VALUES(@UserID, @Message)