But prior to the upcoming 2019 release, SQL Server’s support for scalar functions was fraught with problems. In SQL Server, a function that returns a single ... An example of a non-deterministic ...