How to use the tedious.TYPES.UniqueIdentifierN function in tedious

To help you get started, we’ve selected a few tedious examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github tediousjs / tedious / examples / parameters.js View on Github external
connection.on('connect', function(err){
	var request = new Request("INSERT INTO MyTable (uniqueIdCol, intCol, nVarCharCol) VALUES (@uniqueIdVal, @intVal, @nVarCharVal)",
	function(err){
		if(err){
			console.log(err);
		};
	});

	request.addParameter('uniqueIdVal', TYPES.UniqueIdentifierN,'ba46b824-487b-4e7d-8fb9-703acdf954e5');
	request.addParameter('intVal', TYPES.Int, 435);
	request.addParameter('nVarCharVal', TYPES.NVarChar, 'hello world');

	connection.execSql(request);
});