Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const pool = new sql.ConnectionPool(DatabaseConfig.config);
- pool.connect().then(function () {
- //6.
- debugger;
- var request = new sql.Request(pool);
- //7.
- request.query("select * from [dbo].[tbl_user]").then(function (recordSet) {
- debugger;
- console.log(recordSet);
- sql.close();
- }).catch(function (err) {
- //8.
- debugger;
- console.log(err);
- sql.close();
- });
- }).catch(function (err) {
- //9.
- debugger;
- console.log(err);
- });
- config: {
- server: 'azureserver',
- options: {
- database: 'cccc',
- encrypt: true,
- port: 1433
- },
- user: 'ccc',
- password: 'ccccc'
- }
Add Comment
Please, Sign In to add comment