//renderer
primaryValues = ["val1","val2",...];
ipc.send("addCustomer", "spCreateNewCustomer", primaryValues, "customerAdded");

//main
var config = {
    //all the usual connection string info
}

function executeStoreProcedure(evt, procedure, params, expectedResponse) {
    var conn = new sql.ConnectionPool(config);
    var req = new sql.Request(conn);

    //params = params.split(",");

    var i = 0, len = params.length;

    for(; i < len; i++){
        params[i] = "'" + params[i] + "'";
    }

    params.join(", ");

    var execute = procedure + params;

    conn.connect(function (err) {

        if (err) {
            console.log(err);
            return;
        }

        req.query(execute, function (err, rset) {
            if (err) {
                console.log(err);
                evt.sender.send(expectedResponse, "no");
            } else {
                var result = JSON.stringify(rset.recordset);
                evt.sender.send(expectedResponse, "yes", result);
            }
            conn.close();
        });
    });
}