Referencing a system function from a DB with a lower compatibility level
1
vote
1
answer
259
views
I need to be able to parse a string array with STRING_SPLIT on a SQL 2016 instance. The vendor has required the one user DB we have access to be set with a compatibility level of 100 while the system DBs are at 130. Can STRING_SPLIT and other system functions be referenced when the context is set to the 100-level DB?
Asked by MattyZDBA
(1955 rep)
Nov 16, 2021, 11:05 PM
Last activity: May 29, 2025, 07:06 PM
Last activity: May 29, 2025, 07:06 PM