SqlFunctions.Sign Method

Definition

Overloads

Sign(Nullable<Decimal>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

Sign(Nullable<Double>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

Sign(Nullable<Int32>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

Sign(Nullable<Int64>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

Sign(Nullable<Decimal>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

[System.Data.Entity.DbFunction("SqlServer", "SIGN")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="arg")]
public static Nullable<decimal> Sign (Nullable<decimal> arg);
static member Sign : Nullable<decimal> -> Nullable<decimal>
Public Shared Function Sign (arg As Nullable(Of Decimal)) As Nullable(Of Decimal)

Parameters

arg
Nullable<Decimal>

A numeric expression.

Returns

The sign of the input expression.

Attributes

Applies to

Sign(Nullable<Double>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

[System.Data.Entity.DbFunction("SqlServer", "SIGN")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="arg")]
public static Nullable<double> Sign (Nullable<double> arg);
static member Sign : Nullable<double> -> Nullable<double>
Public Shared Function Sign (arg As Nullable(Of Double)) As Nullable(Of Double)

Parameters

arg
Nullable<Double>

A numeric expression.

Returns

The sign of the input expression.

Attributes

Applies to

Sign(Nullable<Int32>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

[System.Data.Entity.DbFunction("SqlServer", "SIGN")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="arg")]
public static Nullable<int> Sign (Nullable<int> arg);
static member Sign : Nullable<int> -> Nullable<int>
Public Shared Function Sign (arg As Nullable(Of Integer)) As Nullable(Of Integer)

Parameters

arg
Nullable<Int32>

A numeric expression.

Returns

The sign of the input expression.

Attributes

Applies to

Sign(Nullable<Int64>)

Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.

[System.Data.Entity.DbFunction("SqlServer", "SIGN")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="arg")]
public static Nullable<long> Sign (Nullable<long> arg);
static member Sign : Nullable<int64> -> Nullable<int64>
Public Shared Function Sign (arg As Nullable(Of Long)) As Nullable(Of Long)

Parameters

arg
Nullable<Int64>

A numeric expression.

Returns

The sign of the input expression.

Attributes

Applies to