|
host_id()
The
system function
host_id()
returns the unique identifier (id) of the
client
process on the operating system.
The function host_id() is a
Transact-SQL
extension. It can be executed by any
user.
Syntax of the System Function host_id()
The parameter of the System Function host_id()
The function host_id() is executed without parameters.
Example for the System Function host_id()
select host_id()
go
-----
2406
Returns the id of the operating system process for the
ASE
client.
The host_id can be used, for example, to display details on a Unix
system process, using the Unix-command ps.
See also:
ASE T-SQL - Aggregate Functions,
audit_event_name(),
col_length(),
col_name(),
curunreservedpgs(),
datachange(),
datalength(),
data_pages(),
data_pgs(),
db_id(),
db_name(),
host_name(),
identity(),
index_col(),
index_colorder(),
isnull(),
lct_admin(),
license_enabled(),
lockscheme(),
next_identity(),
object_id(),
object_name(),
pagesize(),
pointer_size(),
ptn_data_pgs(),
reserved_pages(),
reserved_pgs(),
rowcnt(),
row_count(),
showplan_in_xml(),
syb_sendmsg(),
syb_sendmsg(),
System Functions,
tempdb_id(),
tran_dumpable_status(),
tsequal(),
used_pages(),
used_pgs().
|
