Databases Reference
In-Depth Information
Function Name
Return Type
Description
Compares an encrypted value with an
unencrypted character string value. May
be used to compare the encrypted and
unencrypted forms of a password to
determine whether they match. Returns 1
for a match and 0 for no match.
PWDCONPARE()
Int
Returns the encrypted form of a character
string in hexadecimal form. May be used to
encrypt a password for storage. This value
cannot be decrypted using SQL Server tools
or Transact-SQL commands.
PWDENCRYPT()
VarChar
Like the
@@ROWCOUNT
variable, returns the
number of rows either returned by or
modified by the last statement. Returns a
BigInt
type.
ROWCOUNT_BIG()
BigInt
Like the
@@IDENTITY
variable, this function
returns the last Identity value generated
but is limited to the current session and
scope (stored procedure, batch, or module).
SCOPE_IDENTITY()
Sql_Variant
Returns a flag indicating the state of
a server property. Properties include
Collation
,
Edition
,
Engine Edition
,
InstanceName
,
IsClustered
,
IsFullTextInstalled
,
IsIntegratedSecurityOnly
,
IsSingleUser
,
IsSyncWithBackup
,
LicenseType
,
MachineName
,
NumLicenses
,
ProcessID
,
ProductLevel
,
ProductVersion
, and
ServerName
.
SERVERPROPERTY()
Sql_Variant
Returns the current user name. Function is
called without parentheses.
SESSION_USER
nChar
Returns a flag indicating the state of a
session property. Properties include:
ANSI
_
NULLS
,
ANSI
_
PADDING
,
ANSI
_
WARNINGS
,
ARITHABORT
,
CONCAT
_
NULL
_
YIELDS
_
NULL
,
NUMERIC
_
ROUNDABORT
, and
QUOTED
_
IDENTIFIER
.
SESSIONPROPERTY()
Sql_Variant
Returns the date that statistics for a
specified index were last updated.
STATS_DATE()
DateTime
Returns the current user name. Function is
called without parentheses.
SYSTEM_USER
nVarChar
Returns the user name for a specified
User ID.
USER_NAME()
nVarChar