Can anyone suggest how to know the values that are passed to stored procedures along with the parameters.
The below is my code:
const myspvalues = {
AccountID: req.body.userid
AccountName: req.body.AccountName
Email: req.body.mail
}
const result = await models.sequelize.query(
spAccount_InsertUpdate @UserID= $AccountID
@UserName = $AccountName,
@Email = $Email,
{
bind: myspvalues,
type: models.sequelize.QueryTypes.RAW,
}
);
console.log('myspvalues are:',myspvalues)
I am getting below output:
AccountID: 1
AccountName:'Alisa'
Email:'test@gmail.com'
But, I want the result to be displayed as below:
@UserID = 1
,@UserName = 'Alisa'
,@Email = 'test@gamil.com'
Can anyone suggest how to get the above result with paramters.