Export (0) Print
Expand All

SqlFunctions Methods

The SqlFunctions type exposes the following members.

  Name Description
Public method Static member Acos(Nullable<Decimal>) A mathematical function that returns the angle, in radians, whose cosine is the specified numerical value. This angle is called the arccosine.
Public method Static member Acos(Nullable<Double>) A mathematical function that returns the angle, in radians, whose cosine is the specified numerical value. This angle is called the arccosine.
Public method Static member Ascii Returns the ASCII code value of the left-most character of a character expression.
Public method Static member Asin(Nullable<Decimal>) A mathematical function that returns the angle, in radians, whose sine is the specified numerical value. This angle is called the arcsine.
Public method Static member Asin(Nullable<Double>) A mathematical function that returns the angle, in radians, whose sine is the specified numerical value. This angle is called the arcsine.
Public method Static member Atan(Nullable<Decimal>) A mathematical function that returns the angle, in radians, whose tangent is the specified numerical value. This angle is called the arctangent.
Public method Static member Atan(Nullable<Double>) A mathematical function that returns the angle, in radians, whose tangent is the specified numerical value. This angle is called the arctangent.
Public method Static member Atan2(Nullable<Decimal>, Nullable<Decimal>) Returns the positive angle, in radians, between the positive x-axis and the ray from the origin through the point (x, y), where x and y are the two specified numerical values. The first parameter passed to the function is the y-value and the second parameter is the x-value.
Public method Static member Atan2(Nullable<Double>, Nullable<Double>) Returns the positive angle, in radians, between the positive x-axis and the ray from the origin through the point (x, y), where x and y are the two specified numerical values. The first parameter passed to the function is the y-value and the second parameter is the x-value.
Public method Static member Char Returns the character that corresponds to the specified integer ASCII value.
Public method Static member CharIndex(Byte[], Byte[]) Returns the starting position of one expression found within another expression.
Public method Static member CharIndex(String, String) Returns the starting position of one expression found within another expression.
Public method Static member CharIndex(Byte[], Byte[], Nullable<Int32>) Returns the starting position of one expression found within another expression.
Public method Static member CharIndex(Byte[], Byte[], Nullable<Int64>) Returns the starting position of one expression found within another expression.
Public method Static member CharIndex(String, String, Nullable<Int32>) Returns the starting position of one expression found within another expression.
Public method Static member CharIndex(String, String, Nullable<Int64>) Returns the starting position of one expression found within another expression.
Public method Static member Checksum(Nullable<Boolean>) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Byte[]) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Nullable<DateTime>) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Nullable<DateTimeOffset>) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Nullable<Decimal>) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Nullable<Double>) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Nullable<Guid>) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Nullable<TimeSpan>) Returns the checksum value computed over the input argument.
Public method Static member Checksum(String) Returns the checksum value computed over the input argument.
Public method Static member Checksum(Nullable<Boolean>, Nullable<Boolean>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Byte[], Byte[]) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<DateTime>, Nullable<DateTime>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<Decimal>, Nullable<Decimal>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<Double>, Nullable<Double>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<Guid>, Nullable<Guid>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<TimeSpan>, Nullable<TimeSpan>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(String, String) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<Boolean>, Nullable<Boolean>, Nullable<Boolean>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Byte[], Byte[], Byte[]) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<DateTime>, Nullable<DateTime>, Nullable<DateTime>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<DateTimeOffset>, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<Decimal>, Nullable<Decimal>, Nullable<Decimal>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<Double>, Nullable<Double>, Nullable<Double>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<Guid>, Nullable<Guid>, Nullable<Guid>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(Nullable<TimeSpan>, Nullable<TimeSpan>, Nullable<TimeSpan>) Returns the checksum value computed over the input arguments.
Public method Static member Checksum(String, String, String) Returns the checksum value computed over the input arguments.
Public method Static member ChecksumAggregate(IEnumerable<Int32>) Returns the checksum of the values in a collection. Null values are ignored.
Public method Static member ChecksumAggregate(IEnumerable<Nullable<Int32>>) Returns the checksum of the values in a collection. Null values are ignored.
Public method Static member Cos(Nullable<Decimal>) Returns the trigonometric cosine of the specified angle, in radians, in the specified expression.
Public method Static member Cos(Nullable<Double>) Returns the trigonometric cosine of the specified angle, in radians, in the specified expression.
Public method Static member Cot(Nullable<Decimal>) A mathematical function that returns the trigonometric cotangent of the specified angle, in radians.
Public method Static member Cot(Nullable<Double>) A mathematical function that returns the trigonometric cotangent of the specified angle, in radians.
Public method Static member CurrentTimestamp Returns the current date and time.
Public method Static member CurrentUser Returns the name of the current user.
Public method Static member DataLength(Nullable<Boolean>) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(Byte[]) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(Nullable<DateTime>) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(Nullable<DateTimeOffset>) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(Nullable<Decimal>) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(Nullable<Double>) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(Nullable<Guid>) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(Nullable<TimeSpan>) Returns the number of bytes used to represent any expression.
Public method Static member DataLength(String) Returns the number of bytes used to represent any expression.
Public method Static member DateAdd(String, Nullable<Double>, Nullable<DateTime>) Returns a new datetime value based on adding an interval to the specified date.
Public method Static member DateAdd(String, Nullable<Double>, Nullable<DateTimeOffset>) Returns a new date value based on adding an interval to the specified date.
Public method Static member DateAdd(String, Nullable<Double>, Nullable<TimeSpan>) Returns a new time span value based on adding an interval to the specified time span.
Public method Static member DateAdd(String, Nullable<Double>, String) Returns a new datetime value based on adding an interval to the specified date.
Public method Static member DateDiff(String, Nullable<DateTime>, Nullable<DateTime>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<DateTime>, Nullable<DateTimeOffset>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<DateTime>, Nullable<TimeSpan>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<DateTime>, String) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<DateTimeOffset>, Nullable<DateTime>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<DateTimeOffset>, Nullable<DateTimeOffset>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<DateTimeOffset>, Nullable<TimeSpan>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<DateTimeOffset>, String) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<TimeSpan>, Nullable<DateTime>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<TimeSpan>, Nullable<DateTimeOffset>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<TimeSpan>, Nullable<TimeSpan>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, Nullable<TimeSpan>, String) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, String, Nullable<DateTime>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, String, Nullable<DateTimeOffset>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, String, Nullable<TimeSpan>) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateDiff(String, String, String) Returns the count of the specified datepart boundaries crossed between the specified start date and end date.
Public method Static member DateName(String, Nullable<DateTime>) Returns a character string that represents the specified datepart of the specified date.
Public method Static member DateName(String, Nullable<DateTimeOffset>) Returns a character string that represents the specified datepart of the specified date.
Public method Static member DateName(String, Nullable<TimeSpan>) Returns a character string that represents the specified datepart of the specified date.
Public method Static member DateName(String, String) Returns a character string that represents the specified datepart of the specified date.
Public method Static member DatePart(String, Nullable<DateTime>) Returns an integer that represents the specified datepart of the specified date.
Public method Static member DatePart(String, Nullable<DateTimeOffset>) Returns an integer that represents the specified datepart of the specified date.
Public method Static member DatePart(String, Nullable<TimeSpan>) Returns an integer that represents the specified datepart of the specified date.
Public method Static member DatePart(String, String) Returns an integer that represents the specified datepart of the specified date.
Public method Static member Degrees(Nullable<Decimal>) Returns the corresponding angle in degrees for an angle specified in radians.
Public method Static member Degrees(Nullable<Double>) Returns the corresponding angle in degrees for an angle specified in radians.
Public method Static member Degrees(Nullable<Int32>) Returns the corresponding angle in degrees for an angle specified in radians.
Public method Static member Degrees(Nullable<Int64>) Returns the corresponding angle in degrees for an angle specified in radians.
Public method Static member Difference Returns an integer value that indicates the difference between the SOUNDEX values of two character expressions.
Public method Static member Exp(Nullable<Decimal>) Returns the exponential value of the specified float expression.
Public method Static member Exp(Nullable<Double>) Returns the exponential value of the specified float expression.
Public method Static member GetDate Returns the current database system timestamp as a datetime value without the database time zone offset. This value is derived from the operating system of the computer on which the instance of SQL Server is running.
Public method Static member GetUtcDate Returns the current database system timestamp as a datetime value. The database time zone offset is not included. This value represents the current UTC time (Coordinated Universal Time). This value is derived from the operating system of the computer on which the instance of SQL Server is running.
Public method Static member HostName Returns the workstation name.
Public method Static member IsDate Indicates whether the input value is a valid date or time.
Public method Static member IsNumeric Indicates whether the input value is a valid numeric type.
Public method Static member Log(Nullable<Decimal>) Returns the natural logarithm of the specified input value.
Public method Static member Log(Nullable<Double>) Returns the natural logarithm of the specified input value.
Public method Static member Log10(Nullable<Decimal>) Returns the base-10 logarithm of the specified input value.
Public method Static member Log10(Nullable<Double>) Returns the base-10 logarithm of the specified input value.
Public method Static member NChar Returns the Unicode character with the specified integer code, as defined by the Unicode standard.
Public method Static member PatIndex Returns the starting position of the first occurrence of a pattern in a specified expression, or zeros if the pattern is not found, on all valid text and character data types.
Public method Static member Pi Returns the constant value of pi.
Public method Static member QuoteName(String) Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.
Public method Static member QuoteName(String, String) Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.
Public method Static member Radians(Nullable<Decimal>) Returns the radian measure corresponding to the specified angle in degrees.
Public method Static member Radians(Nullable<Double>) Returns the radian measure corresponding to the specified angle in degrees.
Public method Static member Radians(Nullable<Int32>) Returns the radian measure corresponding to the specified angle in degrees.
Public method Static member Radians(Nullable<Int64>) Returns the radian measure corresponding to the specified angle in degrees.
Public method Static member Rand() Returns a pseudo-random float value from 0 through 1, exclusive.
Public method Static member Rand(Nullable<Int32>) Returns a pseudo-random float value from 0 through 1, exclusive.
Public method Static member Replicate Repeats a string value a specified number of times.
Public method Static member Sign(Nullable<Decimal>) Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Public method Static member Sign(Nullable<Double>) Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Public method Static member Sign(Nullable<Int32>) Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Public method Static member Sign(Nullable<Int64>) Returns the positive (+1), zero (0), or negative (-1) sign of the specified expression.
Public method Static member Sin(Nullable<Decimal>) Returns the trigonometric sine of the specified angle.
Public method Static member Sin(Nullable<Double>) Returns the trigonometric sine of the specified angle.
Public method Static member SoundCode Converts an alphanumeric string to a four-character (SOUNDEX) code to find similar-sounding words or names.
Public method Static member Space Returns a string of repeated spaces.
Public method Static member Square(Nullable<Decimal>) Returns the square of the specified number.
Public method Static member Square(Nullable<Double>) Returns the square of the specified number.
Public method Static member SquareRoot(Nullable<Decimal>) Returns the square root of the specified number.
Public method Static member SquareRoot(Nullable<Double>) Returns the square root of the specified number.
Public method Static member StringConvert(Nullable<Decimal>) Returns character data converted from numeric data.
Public method Static member StringConvert(Nullable<Double>) Returns character data converted from numeric data.
Public method Static member StringConvert(Nullable<Decimal>, Nullable<Int32>) Returns character data converted from numeric data.
Public method Static member StringConvert(Nullable<Double>, Nullable<Int32>) Returns character data converted from numeric data.
Public method Static member StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>) Returns character data converted from numeric data.
Public method Static member StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>) Returns character data converted from numeric data.
Public method Static member Stuff Inserts a string into another string. It deletes a specified length of characters in the target string at the start position and then inserts the second string into the target string at the start position.
Public method Static member Tan(Nullable<Decimal>) Returns the trigonometric tangent of the input expression.
Public method Static member Tan(Nullable<Double>) Returns the trigonometric tangent of the input expression.
Public method Static member Unicode Returns the integer value, as defined by the Unicode standard, for the first character of the input expression.
Public method Static member UserName() Returns a database user name corresponding to a specified identification number.
Public method Static member UserName(Nullable<Int32>) Returns a database user name corresponding to a specified identification number.
Top
Show:
© 2014 Microsoft