> For the complete documentation index, see [llms.txt](https://flowprodocs.wftutorials.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://flowprodocs.wftutorials.com/flowblocks/database/sql-server.md).

# 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>