Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.
I have some json that I would like to parse in SQL Server 2016. There is a hierarchy structure of Projects-&…
json parsing hierarchy sql-server-2016 open-jsonI am new to JSON in SQL. I am getting the error "JSON text is not properly formatted. Unexpected character …
json sql-server-2016 sql-server-jsonI am stuck while accessing array inside json using newly introduced JSON_VALUE function. Please consider following code - IF …
sql sql-server json sql-server-2016I get the following error on secondary replicas when trying to restore an encrypted backup even though the replica has …
sql encryption certificate sql-server-2016 private-keyI'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting …
sql sql-server tsql ssis sql-server-2016I want to use JSON functions in SQL Server 2016, but when I try to execute OPENJSON function, I get the …
sql-server json sql-server-2016The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) . Could not restore the …
sql-server encryption reporting-services sql-server-2016SQL 2016 has a new feature which converts data on SQL server to JSON. I am having difficulty in combining array …
sql json sql-server-2016Can someone give example how to pass JSON type as parameter to SQL Server 2016 stored procedure using ADO.Net in …
c# asp.net json sql-server-2016I am running Windows 10 Pro 64 bit on a dev box that has multiple monitors, 16 gigs DDR4 RAM, 4 Ghz I7, GTX 970. …
sql-server ssms sql-server-2016 ssms-2016