SQL Server internal function summary:
Select @ connections
Select @ cursor_rows
Select @ datefirst
Select @ dbts
Select @ Error
Select @ rowcount
Select @ fetch_status
Select @ cpu_busy as 'cpu Ms', getdate () as 'as'
Select @ identity as 'identified'
Select @ idle as 'idle Ms', getdate () as 'as'
Select @ io_busy as 'IO Ms', getdate () as 'as'
Select @ langid as 'language id'
Select @ language as 'language name'
Select @ lock_timeout
Select @ max_connections
Select @ max_precision
Select @ nestlevel as 'inner level'
Select @ options
Select @ packet_errors
Select @ pack_received
Select @ pack_sent
Select @ procid as 'procid'
Select @ remserver
Select @ servername
Select @ servicename
Select @ spid
Select @ textsize
Set textsize 2048
Select @ textsize
Select @ timeticks
Select @ total_errors as 'errors ', getdate () as 'as'
Select @ total_read as 'reads', @ total_write as 'writes ', getdate () as 'as'
Select @ total_read as 'reads', @ total_write as 'writes ', getdate () as 'as'
Select @ trancount
Select @ version
Select @ fetch_status
Internal variables:
app_name identity (function)
case isdate
cast and convert isnull
coalesce isnumeric
current_timestamp newid
CURRENT_USER nullif
datalength parsename
@ error permissions
formatmessage @ rowcount
getansinull session_user
host_id stats_date
host_name system_user
ident_incr @ trancount
ident_seed user_name
@ identity