I have created stored procedure like below.
CREATE PROCEDURE sp_login
Select * From tbl_login
Where username = @uname and password1=@pword
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?