/// <summary>
/// <para>CHECKSUM_AGG built-in function.</para>
/// <para>Returns the checksum of unique values in a group. Null values are ignored.</para>
/// </summary>
/// <param name="argument">Is an integer expression. Aggregate functions and subqueries are not allowed.</param>
public static SysFn ChecksumAggDistinct(AggregateArgument argument)
{
argument = argument ?? Designer.Null;
return(new SysFn((buildContext, buildArgs) =>
{
var sql = String.Format(
"CHECKSUM_AGG(DISTINCT {0})",
argument.Build(buildContext, buildArgs));
buildContext.TryTakeException(argument.Exception, "Sys.ChecksumAggDistinct");
return sql;
},
argument.chainException));
}
/// <summary>
/// <para>VARP built-in function.</para>
/// <para>Returns the statistical variance for the population for all values in the specified expression.</para>
/// </summary>
/// <param name="argument">Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type. Aggregate functions and subqueries are not permitted.</param>
public static SysFn Varp(AggregateArgument argument)
{
argument = argument ?? Designer.Null;
return(new SysFn((buildContext, buildArgs) =>
{
var sql = String.Format(
"VARP({0})",
argument.Build(buildContext, buildArgs));
buildContext.TryTakeException(argument.Exception, "Sys.Varp");
return sql;
},
argument.chainException));
}
