Dual Pins for Users

[QMcKay]

@JTRTech

This script uses a JSON parser introduced in 2016 which wont work in previous versions.

@Vasilios

Yea I’ve upgraded my SQL database to 2017

It is not enough to upgrade. You need to set the DB Compatibility Level to 130 or higher…

SQL Server Express 2016 / 2017

SQL 2016/2017 JSON Features Why do you want JSON features in SQL 2016/2017? A lot of data in the SambaPOS Database is stored in JSON format. Dealing with JSON in SQL Queries in earlier versions of SQL Server was very difficult. With SQL Server 2016/2017, several features were added to make dealing with JSON data much easier. You might not think you need to use these features now, but enabling support for JSON is very simple. TIP: More and more Tutorials and DB Tools files contain SQL…