ConnectionPromises.Function.execSql

tedious-plus / ConnectionPromises / execSql

Function: execSql()

function execSql(connection, request): Promise<RequestResult>;

Defined in: ConnectionPromises.ts:246

Executes an SQL query and returns the result.

This is a promisified version of Connection.execSql(). Output rows are buffered in an array and returned on completion.

Usage:

const request = new Tedious.Request("select name from sys.databases", () => {});
const result = await ConnectionPromises.execSql(connection, request);
console.log(result.rows);

Parameters

connection

Connection

An open Tedious connection.

request

Request

The Tedious request to be executed.

Returns

Promise<RequestResult>

A promise for the result of the request. The promise is rejected when the request fails.