Sample Header Ad - 728x90

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