System Functions
The .NET Framework Data Provider for SQL Server (SqlClient) provides the following system functions:
| Function | Description |
|---|---|
CHECKSUM ( value, [value, [value]]) |
Returns the checksum value. CHECKSUM is intended for use in building hash indexes.Arguments value: A Boolean, Byte, Int16, Int32, Int64, Single, Decimal, Double, DateTime, String, Binary, or Guid. You can specify one, two or three values.Return Value The absolute value of the specified expression. Example SqlServer.CHECKSUM(10,100,1000.0) |
CURRENT_TIMESTAMP () |
Produces the current date and time in SQL Server internal format for DateTime values with a precision of 7 in SQL Server 2008 and a precision of 3 in SQL Server 2005.Return Value The current system date and time as a DateTime.Example SqlServer.CURRENT_TIMESTAMP() |
CURRENT_ USER () |
Returns the name of the current user. Return Value An ASCII String.Example SqlServer.CURRENT_USER() |
DATALENGTH ( expression ) |
Returns the number of bytes used to represent any expression. Arguments expression: A Boolean, Byte, Int16, Int32, Int64, Single, Decimal, Double, DateTime, Time, DateTimeOffset, String, Binary, or Guid.Return Value The size of properties as an Int32.Example SELECT VALUE SqlServer.DATALENGTH(P.Name)FROMAdventureWorksEntities.Product AS P |
HOST_NAME() |
Returns the workstation name. Return Value A Unicode String.Example SqlServer.HOST_NAME() |
ISDATE( expression ) |
Determines whether an input expression is a valid date. Arguments expression: A Boolean, Byte, Int16, Int32, Int64, Single, Decimal, Double, DateTime, Time, DateTimeOffset, String, Binary, or Guid.Return Value An Int32. One (1) if the input expression is a valid date. Zero (0) otherwise.Example SqlServer.ISDATE('1/1/2006') |
ISNUMERIC( expression ) |
Determines whether an expression is a valid numeric type. Arguments expression: A Boolean, Byte, Int16, Int32, Int64, Single, Decimal, Double, DateTime, Time, DateTimeOffset, String, Binary, or Guid.Return Value An Int32. One (1) if the input expression is a valid date. Zero (0) otherwise.Example SqlServer.ISNUMERIC('21') |
NEWID() |
Creates a unique value of type Guid. Return Value A Guid.Example SqlServer.NEWID() |
USER_NAME( id ) |
Returns a database user name from a specified identification number. Arguments expression: An Int32 identification number associated with a database user.Return Value A Unicode String.Example SqlServer.USER_NAME(0) |
For more information about the String functions that SqlClient supports, see String Functions (Transact-SQL).