What's new in SQL Server 2016? | SQL Server 2016 New Features | Important New Features in SQL Server 2016

Important New Features in SQL Server 2016

• 1 DROP IF EXISTS in Sql Server 2016
• 2 JSON Support In Sql Server 2016
  • 2.1 FOR JSON Clause
  • 2.2 OPENJSON Function
  • 2.3JSON_VALUE Function
  • 2.4 JSON_MODIFY Function
  • 2.5 ISJSON Function
  • 2.6 JSON_QUERY Function
  • 2.7 Indexing Strategy For JSON Value In Sql Server 2016
  • 2.3 lax and strict JSON Path Modes
• 3 STRING_SPLIT Function In Sql Server 2016
• 4 FORMATMESSAGE Function In Sql Server 2016
• 5 Temporal Tables In Sql Server 2016
• 6 Row Level Security In Sql Server 2016
• 7 Query Store In Sql Server 2016
• 8 COMPRESS, GZIP and DECOMPRESS Functions In Sql Server 2016
• 9 DATEDIFF_BIG Function In Sql Server 2016
• 10 Live Query Statistics In Sql Server 2016
• 11 DATEDIFF VS DATEDIFF_BIG Functions In Sql Server
• 12 Compare Execution Plans In Sql Server 2016
• 13 SESSION_CONTEXT In Sql Server 2016
• 14 Dynamic Data Masking In Sql Server 2016
• 15 Page Allocation Changes In Sql Server 2016
• 16 ALTER COLUMN Operation Online
• 17 AT TIME ZONE In Sql Server 2016