Temporal Data with System Versioned Tables in SQL Server 2016

SQL Server 2016 will be coming with Temporal Data support following the ANSI SQL 2011 standard. This will add support for Temporal Tables as a Database feature that will provide a built-in support to provide information about data stored in the table at any point in time rather than only the data that is correct at the current…

2

Export SQL Table or a Query data to JSON string format | SQL Server 2016

As many of you know that in SQL Server 2016 there will be support for JSON data, and with the release of CTP2 you can play with the some of the features of JSON, but with CTP3/RTM JSON will be fully supported.   – With this CTP2 release you can only export data as JSON string. – But with…

1