SQL Server Concepts
Posted in SQL Server

STRING_SPLIT – New function in SQL Server 2016

As part of SQL Server 2016 enhancements, a new built-in table-valued function STRING_SPLIT() is introduced.  This is one of the many enhancements introduced in SQL…

Continue Reading...
SQL Server Concepts
Posted in SQL Server

CREATE OR ALTER – New enhancement in SQL Server 2016 SP1

An interesting new enhancement was introduced in SQL Server 2016 SP1. As part of this release, a new T-SQL statement, CREATE OR ALTER was introduced…

Continue Reading...