SQL Server

MSSQL Server connection block

Description

This block allows you to connect to MS SQL server and run queries.

Properties

Database Conn String

The database connection string. This is different from the usual query string format and is the common string that would be used to connect to a database normally.

// Sample Connection String
Server=localhost,1433;Database=database;User Id=username;Password=password;Encrypt=false

Sql Query

The SQL query to execute

Returns

Returns an array of the records with some additional options. This can contain

• recordset - an array of objects containing the query results

• rowsaffected - a count of the number of rows affected

NPM Reference

The block uses mssql package form npm. View here- https://www.npmjs.com/package/mssql