INNER CODE UNIT · JavaScript

insertdata

hussien89aa/AndroidTutorialForBeginners · Web Services/NodeSqlServer.js:42

function insertdata() {

    request = new Request("INSERT into [DB_9E3E00_testing].[dbo].[user] (firstname,lastname)VALUES (@firstname,@lastname);", function(err) {
        if (err) {

            console.log(err);}
    });
    request.addParameter('firstname', TYPES.NVarChar,'hussein');
    request.addParameter('lastname', TYPES.NVarChar , 'alrubaye');

    request.on('row', function(columns) {
        columns.forEach(function(column) {
            if (column.value === null) {
                console.log('NULL');
            } else {
                console.log("item of inserted item is " + column.value);
            }
        });

View source record →