我认为线的
req.input('ProductEntryID', req.Int, 3299);req.input('LoginEntryID', req.Int, 4);req.input('TempLoginEntryId', req.Int, -1);req.input('AddToWishList', req.Bit, 0);req.input('WebPortalId', req.Int, 0);这有req.input那似乎是错误的。
请尝试此代码
var sql = require('mssql');var config = { user: 'sa', password: '---', server: 'localhost', // You can use 'localhost\instance' to connect to named instance database: 'Test'}var getCities = function() { var conn = new sql.Connection(config); conn.connect().then(function(conn) { var request = new sql.Request(conn); request.input('City', sql.VarChar(30), 'Cbe'); request.input('NameNew', sql.VarChar(30), 'Cbe'); request.execute('spTest').then(function(err, recordsets, returnValue, affected) { console.dir(recordsets); console.dir(err); }).catch(function(err) { console.log(err); }); });}getCities();我自己尝试了一下，并给出了结果。
