Table 2-6: New Transact-SQL functions
Function
|
Description
|
|---|
biginttohex
|
Returns the platform-independent
hexadecimal equivalent of the specified integer
|
count_big
|
Returns the number of (distinct) non-null
values or the number of selected rows as a bigint
|
datachange
|
Measures the amount of change in the
data distribution since update statistics
|
data_pages
|
Returns the number of pages used by the
specified table, index, or a specific
|
hextobigint
|
Returns the bigint value
equivalent of a hexadecimal string
|
is_quiesced
|
|
partition_id
|
Returns the partition id of the specified
data or index partition name.
|
partition_name
|
The explicit name of a new partition,
partition_name returns the partition name
|
reserved_pages
|
Reports the number of pages reserved
to a table, index or a specific partition.
|
row_count
|
Returns an estimate of the number of
rows in the specified table.
|
showplan_in_xml
|
|
ssel_message
|
|
tran_dumpable_status
|
|
used_pages
|
Reports the number of pages used by a
table, an index, or a specific partition.
|
xmlvalidate
|
Validates XML documents, including those
containing non-ASCII characters (I18N). Described in XML
Services.
|
