Functions Statistical

Learn about custom T-SQL mathematical and statistical functions with code that can be run directly in the database engine without any external tools.

Title Author Date
Newton Cotes Formula for Numerical Integration in SQL Server Sebastiao Pereira2026-06-22
Graph Theory – Shortest Path Algorithms Sebastiao Pereira2026-06-11
Graham Scan Algorithm in SQL Server Sebastiao Pereira2026-05-18
Fuzzy String Matching Algorithms in SQL Server Sebastiao Pereira2026-05-04
SOFTMAX Function in SQL Server Sebastiao Pereira2026-04-09
OPTICS Clustering Algorithm in SQL Server Sebastiao Pereira2026-02-04
Storing and Reporting on Genealogy Data in SQL Server Sebastiao Pereira2025-10-06
DBSCAN Algorithm in SQL Server Sebastiao Pereira2025-09-19
Graph Minimum Spanning Tree (MST) in SQL Server Sebastiao Pereira2025-06-23
SQL Matrix Calculator and Operations Toolkit Sebastiao Pereira2025-04-09
Calculating Matrix Inverse in SQL Server Sebastiao Pereira2025-04-02
Regression Analysis in SQL Sebastiao Pereira2025-02-06
Calculate Distance Between Two Points with SQL Sebastiao Pereira2025-01-27
How to Find Outliers in SQL Server Sebastiao Pereira2025-01-10