Pro SQL Server on Linux: Including Container-Based Deployment with Docker and Kubernetes

© Bob Ward 2018

Bob WardPro SQL Server on Linuxhttps://doi.org/10.1007/978-1-4842-4128-8_4

4. Building an Application and Advanced T-SQL

Bob Ward¹ 

(1)

North Richland Hills, TX, USA

 

Now that you have learned how to create a database, tables, and execute basic T-SQL queries, it’s time to write some code and build an application that connects to SQL Server on Linux. As in Chapter 3, I’ll use Visual Studio Code as the development environment to build a node.js application.

The node.js application uses basic T-SQL queries based on the knowledge I showed you in Chapter 3. So, in the second part of this chapter, I’ll show you more advanced T-SQL capabilities as well as new features that were shipped in SQL Server 2016 and 2017.

There are three resources I ...