Transaction

gistfile1.js

var transaction = new sql.Transaction(connection);
transaction.begin(function(err) {
 	if(err){
		console.log(1);
		console.log(err);
		transaction.rollback(function(err){
			res.end("\n");
		});
		return;
	}
	//Code here
	//Commit
	setTimeout(function(){
	transaction.commit(function(err) {
		if(err){
			console.log(10);
			console.log(err);
			transaction.rollback(function(err){
				if(err){console.log(err);}
			});
			return;
		}
		console.log("Transaction commited.");
		connection.close();
	});
	},2000);
});