|
A typical authenticate_user SQL script is a call to a stored procedure that uses the parameters authentication_status, ml_username, user_password, and user_new_password. The order of the parameters in the call must match this. For example, in a SQL Anywhere consolidated database, the format is:
call my_authentication( ?, ?, ?, ? )
where the first argument is the authentication code, and so on. The authentication code is an integer type, and the other parameters are VARCHAR(128).
In Transact-SQL, the format is:
execute ? = my_authentication( ?, ?, ? )
where the authentication code is the parameter on the left hand side.