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

• DROP IF EXISTS in Sql Server 2016
• JSON Support In Sql Server 2016
  • FOR JSON Clause
  • OPENJSON Function
  • JSON_VALUE Function
  • JSON_MODIFY Function
  • ISJSON Function
  • JSON_QUERY Function
  • Indexing Strategy For JSON Value In Sql Server 2016
  • lax and strict JSON Path Modes
• STRING_SPLIT Function In Sql Server 2016
• FORMATMESSAGE Function In Sql Server 2016
• Temporal Tables In Sql Server 2016
• Row Level Security In Sql Server 2016
• Query Store In Sql Server 2016
• COMPRESS, GZIP and DECOMPRESS Functions In Sql Server 2016
• DATEDIFF_BIG Function In Sql Server 2016
• Live Query Statistics In Sql Server 2016
• DATEDIFF VS DATEDIFF_BIG Functions In Sql Server
• Compare Execution Plans In Sql Server 2016
• SESSION_CONTEXT In Sql Server 2016
• Dynamic Data Masking In Sql Server 2016
• Page Allocation Changes In Sql Server 2016
• ALTER COLUMN Operation Online
• AT TIME ZONE In Sql Server 2016