Login     Register

        Contact Us     Search

XLeratorDB/engineering Online Documentation

SQL Server IMSQRT function


 
Updated: 27 August 2010

Use IMSQRT to return the square root of a complex number in x + yi or x + yj text format. The square root of a complex number is computed by:

IMSQRT
 
Where
                r = IMABS(@inumber)
                q = IMARGUMENT(@inumber)
Syntax
SELECT [wctEngineering].[wct].[IMSQRT] (
   <@inumber, nvarchar(4000),>)
Arguments
@inumber
is the value at which to evaluate the function. @inumber is an expression of type varchar or of a type that can be implicitly converted to varchar and must be in the format x + yi or x + yj, where x is a real number that can be converted to float and yi (or yj) is an imaginary number, where the y part can be converted to float.
Return Types
varchar(4000)
Remarks
·         Use COMPLEX to convert real and imaginary coefficients into a complex number
Examples

select
wct.IMSQRT('7+24i')

This produces the following result
-----------------------
4+3i
 

(1 row(s) affected)



Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service