Incorrect Syntax near the keyword 'IN'

[waiza]

CREATE PROCEDURE InsertStudent(In p1 nvarchar(50),In p2 nvarchar(50),In p3 nvarchar(50),In p4 nvarchar(50))

AS

BEGIN
INSERT INTO STUDENT(roll,dob,phone,address) values(p1,p2,p3,p4)
END

[PsychoCoder]

I don't see the word In being used in this procedure. Are you sure it's this proc that's erroring on you?

[Rabbit]

Get rid of the IN keyword in your parameter list.

[India777]

CREATE PROCEDURE ProcedureName
@var1 nvarchar(50),
@var2 nvarchar(50)
AS
BEGIN
    ................write insert query here................
END

[NeoPa]

Procedure parameters are not declared with an "IN" keyword. You may be confusing this with the "OUT" | "OUTPUT" keyword which is sometimes used in parameter declarations. See MSDN: CREATE PROCEDURE (Transact-SQL) for the full SP.