var express = require('express'); var app = express(); var sql = require("mssql"); // config for your database const config = { user: 'SA', password: 'PASS', server: '192.168.0.193', // You can use 'localhost\\instance' to connect to named instance database: 'SL', options: { encrypt: true // Use this if you're on Windows Azure } } app.get('/', function (req, res) { sql.connect(config).then(() => { return sql.query`select TOP 10 * from av0_style` }).then(result => { res.send(result); }).catch(err => { // ... error checks }) sql.on('error', err => { // ... error handler }) }); var server = app.listen(4000, function () { console.log('Server is running.. on Port 4000'); })

https://github.com/patriksimek/node-mssql

var express = require('express'); var app = express(); var sql = require("mssql"); const config = { user: 'SA', password: 'PASS', server: '192.168.0.1', database: 'SL', options:{encrypt: true} } app.get('/', function (req, res) { new sql.ConnectionPool(config).connect().then(pool => { return pool.query`select TOP 100 * from av0_style` }).then(result => { res.send(result); }).catch(err => { console.log(err) }) }); var server = app.listen(4000, function () { console.log('Server is running.. on Port 4000'); }); 23.12.17

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024