var sql = require('mssql'),
    connectionObj = {
        user: 'myUser',
        password: 'myPassword',
        server: 'http://mysqlserver.whatever'
        options: {
            database: 'myDB'
        }
    };

/**
 * Opens connection to sql server.
 *
 * @return {Object} Connection object.
 */
function openConnection() {
    var connection = new sql.Connection(connectionObj);
    return connection;
};

/**
 * Closes connection.
 *
 * @param {Object} connection - Connection Object.
 * @return {Promise} Promise.
 */
function closeConnection(connection) {
    return connection.close();
};

/**
 * Does a request to sql server.
 *
 * @param {Object} connection - Connection object.
 * @param {string} query - Query string to compute.
 * @return {Promise} Promise.
 */
function doRequest(connection, query) {
    return connection.request().query(query);
};

/**
 * Gets Request.
 *
 * @param {Object} connection - Connection object.
 */
function getRequest(connection) {
    return new sql.Request(connection);
};

var request, conn = openConnection();

conn.connect()
    .then(function() {
        request = getRequest(conn);
        return request.execute('usp_get_Masters');
    })
    .then(function(result) {
        console.log(result); // Here in result you have the result of the stored procedure execution.
    });