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 @@ROWCOUNTWhat am I doing wrong in regards to assigning value to variables as parameters?