We're developing against SQL Server 2019 currently, but we have a need to deploy the same set of SQL scripts to a SQL Server 2014 database.
For example, in SQL Server 2019 a built-in function called
TRIM exists but this is not supported in SQL Server 2014. To make sure we're only using syntaxes supported by both databases, I'm wondering if there's a solution to just allow 2014 syntaxes in 2019.
I thought altering compatibility mode of the database would have this effect, but this does not have the intended effect.