How to node connect msSql locally
const sql = require("mssql/msnodesqlv8");
var config = {
server : "LAPTOP-N080klk\\SQLEXPRESS",
database:"testdb",
driver:"msnodesqlv8",
options:{
trustedConnection:true
}
}
sql.connect(config,(err)=>{
if(err){console.log("error-->"); return }
var req = new sql.Request()
req.query("select * from users",function(err,records){
if(err){console.log(err)}
else{
console.log(records)
}
})
})
Comments
Post a Comment