Loading

Error in stored procedure "incorrect syntax near"

Mike Jonson

Create next stored procedure

CREATE PROCEDURE dbo.SearchDebiors

(
@debName nvarchar(50)
@postNumb nvarchar(50)
@phoneNumb nvarchar(50)
)

AS
select * from Debitors where
[Name] like '%'+@debName+'%' and
cast(PostNumber as nvarchar(50)) like '%'+@postNumb+'%' and
(PhoneNumber like '%'+@phoneNumb+'%' or PhoneNumber is null)
RETURN

and cant save, every time error "incorrect syntax near @postNumb", must declare the scale variable @debName. Please help why?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Shekhawat15y ago
Accepted answer
CREATE PROCEDURE dbo.SearchDebiors

(
@debName nvarchar(50),
@postNumb nvarchar(50),
@phoneNumb nvarchar(50)
)

AS
select * from Debitors where
[Name] like '%'+@debName+'%' and
cast(PostNumber as nvarchar(50)) like '%'+@postNumb+'%' and
(PhoneNumber like '%'+@phoneNumb+'%' or PhoneNumber is null)
RETURN

use comma in declaration part in above i marked with green color. Error in parameter declaration part that i have bold use comma(,) to seprate each parameter.
0
Akkiraju Ivaturi15y ago
Yes. Missing commas. Every parameter declared must be seperated by commas and also, if you do not want to pass value to the parameter, then make parameter value to NULL. Eg: @debName nVarchar(50)=NULL
0