SQL Server GAMMAINC Function

Updated 2024-03-08 15:10:41.780000

Description

Use GAMMAINC to calculate the incomplete gamma function. This is the equivalent of the Gamma[a,z] function in Mathematica.

\Gamma(a,x)=\int_x^{\infty}t^{a-1}e^{-t}\,dt

Syntax

SELECT [westclintech].[wct].[GAMMAINC] (
  <@A, float,>
 ,<@X, float,>)

Arguments

@A

a value to be passed to the function. @A is an expression of type float or of a type that can be implicitly converted to float.

@X

a value to be passed to the function. @X is an expression of type float or of a type that can be implicitly converted to float.

Return Type

float

Remarks

If @A = 0 or @X = 0, GAMMAINC returns an error.

Examples

select wct.GAMMAINC(2, 2);

This produces the following result.