Multiple choice technology databases

SPLIT function is available in SQL server 2005?

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SPLIT string function was NOT available in SQL Server 2005. It was introduced in SQL Server 2016. Earlier versions required workarounds using CHARINDEX, SUBSTRING, XML methods, or custom user-defined functions to split strings.