CREATE FUNCTION dbo.SplitString (@str NVARCHAR(MAX), @delimiter CHAR(1)) RETURNS TABLE AS RETURN ( SELECT value FROM STRING_SPLIT(@str, @delimiter) ) SELECT @@VERSION --SELECT compatibility_level FROM sys.databases WHERE name = DB_NAME(); ---- 将兼容级别设为130(SQL Server 2016) --ALTER DATABASE meizonglian SET COMPATIBILITY_LEVEL = 130;