Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server gamma function


GAMMA
Updated: 30 May 2017

Use the SQL Server scalar function GAMMA to calculate Γ(z). The GAMMA function can be defined as a definite integral for R[z] > 0.

Syntax
SELECT [wct].[GAMMA] (
   <@Z, float,>)
Arguments
Input NameDefinition
@zThe value of interest
Return Type
float
Remarks
Examples
Example #1
SELECT wct.GAMMA(2.5) as Gamma

This produces the following result.

Example #2
SELECT wct.GAMMA(-3.75) as Gamma

This produces the following result.

Example #3

The following SQL can be run using the SeriesFloat function to create GAMMA values from -4 to 4 which can then be pasted into Excel and graphed.

SELECT
    z,
    wct.GAMMA(z) as Gamma
FROM (
    SELECT
        SeriesValue as z
    FROM
        wct.SeriesFloat(-4,4,0.01,NULL,NULL)
    )n

This produces the following result.

See Also


Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service