Top "Sql-server-2016" questions

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

SQL Server 2016 JSON: Select array of strings instead of array of objects

I am new to JSON in SQL Server and can't figure out how to return a simple array of strings: …

arrays sql-server json sql-server-2016
How can I use System-Versioned Temporal Table with Entity Framework?

I can use temporal tables in SQL Server 2016. Entity Framework 6 unfortunately does not know this feature yet. Is there the …

c# sql entity-framework sql-server-2016 temporal
How can I delete the columns in DataFlow Task in SSIS?

I use SQL Server 2016 and I have a very busy DataFlow task. In my DataFlow task, I use Multicast component …

sql-server ssis sql-server-2016 ssis-2016
How to Stopping System-Versioning on a System-Versioned Temporal Table in SQL Server 2016?

I have a table that has system versioning (temporal table), but I can not see a design environment visually. I …

sql-server sql-server-2016 temporal-tables
How to force SQL Server to return empty JSON array

I'm using SQL Server 2016, which supports JSON PATH to return JSON string. I wonder how to get just a simple …

sql-server json sql-server-2016
Everytime I start SQL Server Agent job I get an error log

Every time I start an Sql Server job, I get the following error. I am using SQL Server 2016. Does not …

sql-server-agent sql-server-2016