Login     Register

        Contact Us     Search

XLeratorDB/math Documentation

SQL Server SECH function


SECH
Updated: 25 Apr 2017

Use the scalar function SECH to calculate the hyperbolic secant of an angle specified in radians.

Syntax
SELECT [wct].[SECH] (
   <@Z, float,>)
Arguments
Input NameDescription
@ZThe number of interest. @Z must be of type float or of a type that implicitly converts to float.
Return Type
float
Remarks
Examples
Example #1
SELECT
    wct.SECH(RADIANS(45e+0)) as SECH

This produces the following result.

Example #2

The following SQL can be run and the results pasted into Excel to graph the results of the function in the range -10, 10.

SELECT
     SeriesValue as z
    ,wct.SECH(Seriesvalue) as SECH
FROM
    wct.SERIESFLOAT(-10,10,.01,NULL,NULL)

Here's the graph of the results.

See Also


Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service