Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.
I need to create a JSON output from a query that uses inner join between two tables with a one …
json sql-server tsql sql-server-2016After upgrading SQL Server 2014 to SQL Server 2016 (both Enterprise editions), I can't start mirror. This works normally on SQL Server 2014. …
sql-server-2016 sql-server-administrationI've SQL server 2016 running on windows 2012 R2 and I applied the patch for TLSv1.2 support and rebooted the VM, https://…
java .net sql-server sql-server-2016 tls1.2There are JSON Function in SQL 2016 like JSON_VALUE, JSON_QUERY and other. I would like to use it in …
sql sql-server json sql-server-2016I have a SQL column that has a single JSON array: {"names":["Joe","Fred","Sue"]} Given a search string, how …
sql arrays tsql sql-server-2016 json-queryYou know about the new JSON_ support in SQL Server 2016 so let's say I have this data in a row { "…
json sql-server-2016Can we run SSIS Package without integration services? If Yes then what are the steps? If No then what is …
sql-server ssis etl sql-server-2016 ssis-2016So I recently installed SQL Server 2016 CTP3 mainly for the JSON output feature. I am trying to using it in …
sql json sql-server-2016I'm trying to figure out why the BULK INSERT command I'm using isn't recognizing the FORMAT and FIELDQUOTE options used …
sql sql-server sql-server-2016Using PostgreSQL I can have multiple rows of json objects. select (select ROW_TO_JSON(_) from (select c.name, c.…
sql-server sql-server-2016