How to use the SmallInt function from mssql

index.js

GitHub: IsraelSistemas/rest-mssql-nodejs

139
140
141
142
143
144
145
146
147
148
case 'tinyint':
    type = mssql.TinyInt;
    
    break;
case 'smallint':
    type = mssql.SmallInt;
    
    break;
case 'int':
    type = mssql.Int;

6

6

1

db.js

GitHub: burke1791/march-madness-calcutta-api

27
28
29
30
31
32
33
34
35
36
  }
};

const Bit = sql.Bit;
const TinyInt = sql.TinyInt;
const SmallInt = sql.SmallInt;
const Int = sql.Int;
const BigInt = sql.BigInt;
const Varchar = (length) => sql.VarChar(length);
const NVarchar = (length) => sql.NVarChar(length);

0

4

2

+ 3 other calls in file

balanceGeneralController.js

GitHub: ernestolopezvv/itcorp-backend

26
27
28
29
30
31
32
33
34
35
}
else {
    comp = true;


//const idEmpresa = sql.SmallInt(EmpresaID);
const cuentas = await pool.request().query("SELECT Codigo, Nombre, Nivel, c.DeudoraInicial, b.AcreedoraInicial, IIF(b.TipoSaldo = 'A', 'A', 'D' ) AS TipoSaldo FROM [dbo].[cuenta] a FULL JOIN(SELECT ID_Cuenta, [Saldo] AS AcreedoraInicial, TipoSaldo = 'A' FROM [dbo].[cuenta] WHERE [Tipo] LIKE ('B%') OR [Tipo] LIKE ('D%') OR [Tipo] LIKE ('F%') OR [Tipo] LIKE ('H%'))b ON a.ID_Cuenta = b.[ID_Cuenta] FULL JOIN(SELECT ID_Cuenta, [Saldo] AS DeudoraInicial FROM [dbo].[cuenta] WHERE [Tipo] LIKE ('A%') OR [Tipo] LIKE ('G%')) c ON a.ID_Cuenta = c.[ID_Cuenta] AND a.ID_Empresa =  '" + idEmpresa + "';");
const listaCuentas = cuentas.recordsets[0];
console.log("listaCuentas");
console.log(idEmpresa);

1

0

0

commercial-release.js

GitHub: DEVFBA/gtc-services-portal-api

15
16
17
18
19
20
21
22
23
24
//Creando la tabla UDT
var udtCommercialRelease = new sql.Table();
// Las columnas deben corresponder con las creadas en la base de datos.   
udtCommercialRelease.columns.add('Id_Item', sql.VarChar(50));  
udtCommercialRelease.columns.add('Id_Country', sql.VarChar(10));
udtCommercialRelease.columns.add('Id_Status_Commercial_Release', sql.SmallInt(2));
udtCommercialRelease.columns.add('Final_Effective_Date', sql.DateTime(8));
udtCommercialRelease.columns.add('Modify_By', sql.VarChar(50));
udtCommercialRelease.columns.add('Modify_Date', sql.DateTime(8));
udtCommercialRelease.columns.add('Modify_IP', sql.VarChar(20));

0

0

0