News

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’ve found them. In a previous Practical .NET column I showed ...
With SQL Server 2016, it now makes sense to store JSON objects in your database (even though there’s no JSON datatype). Here’s how to query JSON properties to find the rows you want.
Users have been clamoring for native JSON support in MSSQL server for years now. With the upcoming 2016 release, Microsoft attempts, and fails, to fulfill the request.
JSON built-in functions use JavaScript-like syntax to reference values and objects in JSON text via second parameter. The OPENJSON function enables you to reference some array in JSON text and return ...