I'm having trouble with inserting a value into a database through node.js. Here is the offending code:

sql.query(conn_str
    ,"INSERT INTO Login(email, hash, salt, firstName, lastName) VALUES(?, ?, ?, ?, ?);
      SELECT SCOPE_IDENTITY() AS 'Identity';"
    , [email, hash, salt, firstName, lastName], function(err, results){
       console.log(results)
    }

Unfortunately, the console is just echoing [], meaning results is an empty array, I suppose.

Does anyone know why the identity is not being returned? Even if it was null, why isn't results then [{Identity: null }] ?

Database is on Azure, which does have a "Scope_Identity" function, and the native client also recognises this function.

Using node package "msnodesql"

Please Help