Top "Sql-server-2016" questions

Use this tag for questions specific to the 2016 version of Microsoft's SQL Server.

Create nested JSON arrays using FOR JSON PATH

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-2016
SQL Server 2016 _can't start mirror

After 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-administration
Sql Server 2016: Enable TLS 1.2 for SQL Server Connection

I'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.2
How to check are there JSON Functions by SQL query?

There 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-2016
How to search SQL column containing JSON array

I 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-query
Get length of json array in SQL Server 2016

You know about the new JSON_ support in SQL Server 2016 so let's say I have this data in a row { "…

json sql-server-2016
Run SSIS Package Without SQL Server Integration Services

Can 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-2016
Incorrect syntax near 'JSON' - SQL Server 2016

So I recently installed SQL Server 2016 CTP3 mainly for the JSON output feature. I am trying to using it in …

sql json sql-server-2016
Incorrect syntax near format in BULK INSERT?

I'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-2016
Get multiple rows using FOR JSON clause

Using PostgreSQL I can have multiple rows of json objects. select (select ROW_TO_JSON(_) from (select c.name, c.…

sql-server sql-server-2016