All code examples have been run on SQL Server 2016 against the 2016 backup of the AdventureWorks database.
You need five things to run these examples.
- A copy of SQL Server Developer Edition which can be downloaded for free from the Microsoft website.
- A copy of the 2016 version of the AdventureWorks database. Instructions on how to download and install the database files can be found here.
- Once you have the database installed, you need to create another database called "demo". This database will be used when we need to create things and we do not want to mess up AdventureWorks.
- The last thing you need is the code. You can cut and paste code right from the screen, or you can download it from the GitHub repo here.