>CREATE Procedure VerifyLogin > @UserID varchar(50), > @Password varchar(50) >) >As > select AccountID, > FirstName + ' ' + LastName AS Name > from accounts > where UserID = @UserID > and Password = @Password > > return @@ROWCOUNT > ><B>However, if I call this next stored procedure with ("user","password",1234,"Name"), it returns no matching record.</B> > >CREATE Procedure VerifyLogin >( > @userid varchar(50), > @Password varchar(50), > @AccountID int, > @Name varchar(100) >) >As > select @AccountID = AccountID, > @Name = FirstName + ' ' + LastName > from accounts > where userid = @userid > and Password = @Password > > return @@ROWCOUNT >>