Error in stored procedure incorrect syntax near

Question

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?

Sandeep Shekhawat · 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.

Akkiraju Ivaturi · Answer

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

Error in stored procedure "incorrect syntax near"