mssql query node js
const sql = require('mssql')
const query=`select * from table`;
config = {
database: "dbname",
// can keep these option required with latest version of mssql npm package
options: {
enableArithAbort: true,
encrypt: true,
rowCollectionOnRequestCompletion: false,
},
parseJSON: true,
password: "password",
port: port, // if youe database running on difrent port then 1433
server: "server ip or name",
user: "usenme",
};
sql.on('error', err => {
// ... error handler
})
sql.connect(config).then(pool => {
return pool.request()
.query(query)
}).then(result => {
console.log(result.recordset)
}).catch(err => {
console.log(err)
});
Also in JavaScript:
- react native: how to know th softkey height
- javascript get all characters before a certain one
- js !==
- javascript title string
- rounding off in javascript
- change url without reloading
- expect any function jest
- jquery set max attribute value
- detect user browser javascript
- Changes not staged for commit: modified: ../package.json
- jquery iterate obj
- auto clicker javascript
- download file in jquery
- jest axios manual mock
- javascript how to disable a button
- how to move an ellipse along the x axis in javascript
- ajax add header
- javascript redirection
- js split string
- icon api node js to browser
- htmlWebpackPlugin.options.title
- javascript video player
- remove header border react native
- jquery get padding of element