Examples of using MSSQL QueryRaw in Mobile Services

updateOne.js

var mssql = request.service.mssql;
var sql = "UPDATE TableA SET valueOne = ? WHERE userId = ?;UPDATE TableB SET valueTwo = ? WHERE userId = ?;";
mssql.queryRaw(sql, [item.valueOne, user.userId, item.valueTwo, user.userId], {
    success: function(results) {
      request.respond(200, { Status: 'SUCCESS', Details: 'Tables have been updated'});
    },
    error: function(error) {
        console.error("Error updating tables: ", error);
        request.respond(500, 'Error updating email address');             
    }
});

updateTrack.js

var mssql = request.service.mssql;
var sql = "UPDATE TableA SET valueOne = ? WHERE userId = ?;UPDATE TableB SET valueTwo = ? WHERE userId = ?;";
var responseCount = 0;
mssql.queryRaw(sql, [item.valueOne, user.userId, item.valueTwo, user.userId], {
    success: function(results) {
      if (responseCount++ == 1) {
        request.respond(200, { Status: 'SUCCESS', Details: 'Tables have been updated'});
      }
    },
    error: function(error) {
        console.error("Error updating tables: ", error);
        if (responseCount++ == 1) {
          request.respond(500, 'Error updating email address');             
        }
    }
});