1. Referensi API
  2. @samveys/mssql

@samveys/mssql

Driver Microsoft SQL Server (tedious lewat mssql)

Versi
1.0.35 Nov 2026
Pasang
pnpm add @samveys/mssql
Dokumentasi
README paket ini

Daftar ini dibaca dari versi 1.0.2; jalankan pnpm sync untuk memperbaruinya.

Import 
import { mssql, mssqlColumnSql, mssqlDialect, mssqlDriver } from '@samveys/mssql'

Fungsi (2)

mssql Fungsi

A SQL Server connection config: `mssql({ host: '127.0.0.1', user: 'sa', password, database: 'app' })`.

function mssql(options: MssqlOptions): ConnectionConfig<MssqlOptions>;

Diekspor dari packages/mssql/src/index.ts

mssqlColumnSql Fungsi

SQL Server type for a schema-builder column.

function mssqlColumnSql(column: ColumnDefinition): string;

Diekspor dari packages/mssql/src/dialect.ts

Nilai (2)

mssqlDialect Nilai

The SQL Server dialect. Identifiers are bracket-quoted (`[users]`), which works whatever `QUOTED_IDENTIFIER` is set to. Pagination is `OFFSET … ROWS FETCH NEXT … ROWS ONLY`, which needs an ORDER BY, so an unordered query gets `order by (select null)`. Inserts use `OUTPUT inserted.*` (ADR 0014).

const mssqlDialect: Dialect;

Diekspor dari packages/mssql/src/dialect.ts

mssqlDriver Nilai

Tidak ada komentar dokumentasi.

const mssqlDriver: DatabaseDriver<MssqlOptions>;

Diekspor dari packages/mssql/src/index.ts

Interface (1)

MssqlOptions Interface

Tidak ada komentar dokumentasi.

interface MssqlOptions {
    readonly host: string;
    readonly port?: number;
    readonly user: string;
    readonly password: string;
    readonly database: string;
    /** TLS to the server. Default false; `trustServerCertificate` accepts a self-signed certificate. */
    readonly encrypt?: boolean;
    readonly trustServerCertificate?: boolean;
    readonly pool?: {
  …
Tampilkan seluruh deklarasi (13 baris) 
interface MssqlOptions {
    readonly host: string;
    readonly port?: number;
    readonly user: string;
    readonly password: string;
    readonly database: string;
    /** TLS to the server. Default false; `trustServerCertificate` accepts a self-signed certificate. */
    readonly encrypt?: boolean;
    readonly trustServerCertificate?: boolean;
    readonly pool?: {
        readonly max?: number;
    };
}

Diekspor dari packages/mssql/src/index.ts