I have created stored procedure like below.
CREATE PROCEDURE sp_login
@uname varchar(20)
@pword varchar(20)
AS
Select * From tbl_login
Where username = @uname and password1=@pword
Go
Open in new window
while execution it is giving errors as
Incorrect syntax near '@pword'.
Must declare the scalar variable "@uname".
can't I declare two variables as varchar?