on a imprecision test:
pydef py_sin(s):
"sinus function : example loading module, handling input/output as strings"
import math as py_math
return ("%s" % py_math.sin(s*1));
WITH RECURSIVE
cnt(x) AS (
SELECT 1
UNION ALL
SELECT x+1 FROM cnt
LIMIT 30000
)
select sum(sin(x)) , sum(py_sin(x)) from cnt
gives :
1.0597896088923804 , 1.0597896088923986
vs for sqlserver
1.05978960889238
==> so having the math function included is slightly better for precision.
sqlserver code:
WITH
cnt(x) AS (
SELECT 1
UNION ALL
SELECT x+1 FROM cnt
where x <=30000
)
select sum(sin(x)) from cnt
option (MAXRECURSION 31000) -- sqlserver 2019 (standard) is limited to 32767 recursions