You can view your database’s compatibility level in SQL Server Management Studio ... my table’s FirstName and LastName columns to the properties on this "nested" object, like this: SELECT * FROM ...

With SQL Server 2016, you can store JSON objects in your rows. Here’s how to work with JSON objects, including how to update them once you ... converted to a virtual table, effectively creating a ...

SQL Server Management Studio (SSMS ... clicking on any of these columns, you can sort the displayed objects by them. So questions like “What are the largest tables?” are now answerable ...