|
|
|
|
|
|
| ASE12.5全局变量(仅供参考,非官方资料,本人个人积累) |
|
| 作者：武汉SEO闵涛 文章来源：敏韬网 点击数909 更新时间：2009/4/22 23:09:39 文章录入：mintao 责任编辑：mintao |
|
|
|
@@authmech
,@@monitors_active
,@@version_number
,@@msgschema
,@@msgreplytoinfo
,@@msgstatusinfo
,@@msgstatus
,@@msgid
,@@msgtimestamp
,@@msgproperties
,@@msgheader
,@@recovery_state
,@@max_precision
,@@lock_timeout
,@@datefirst
,@@tempdbid
,@@bootcount
,@@boottime
,@@bulkarraysize
,@@bulkbatchsize
,@@stringsize
,@@invalidsuid
,@@maxspid
,@@minspid
,@@version_as_integer
,@@unicharsize
,@@min_poolsize
,@@heapmemsize
,@@maxpagesize
,@@invaliduserid
,@@guestuserid
,@@probesuid
,@@maxgroupid
,@@mingroupid
,@@maxuserid
,@@minuserid
,@@maxsuid
,@@minsuid
,@@ha_local_nodeid
,@@crthaproxy
,@@errorlog
,@@haconnection
,@@failedoverconn
,@@hacmpservername
,@@cmpstate
,@@remotestate
,@@localstate
,@@nodeid
,@@curloid
,@@textptr_parameters
,@@transactional_rpc
,@@cis_rpc_handling
,@@cis_version
,@@scan_parallel_degree
,@@parallel_degree
,@@textcolid
,@@textdbid
,@@textobjid
,@@textts
,@@textptr
,@@identity
,@@mempool_addr
,@@shmem_flags
,@@kernel_size
,@@kernel_addr
,@@transtate
,@@char_convert
,@@maxcharlen
,@@client_csexpansion
,@@client_csname
,@@client_csid
,@@ncharsize
,@@thresh_hysteresis
,@@pagesize
,@@langid
,@@language
,@@servername
,@@isolation
,@@tranchained
,@@textsize
,@@spid
,@@max_connections
,@@dbts
,@@timeticks
,@@options
,@@total_errors
,@@total_write
,@@total_read
,@@packet_errors
,@@connections
,@@pack_sent
,@@pack_received
,@@idle
,@@io_busy
,@@cpu_busy
,@@version
,@@trancount
,@@nestlevel
,@@procid
,@@rowcount
,@@error
,@@sqlstatus
onku 回复于：2005-04-20 13:59:31
@@authmech
@@bootcount
@@boottime
@@bulkarraysize
@@bulkbatchsize
@@char_convert
@@cis_rpc_handling
@@cis_version
@@client_csexpansion
@@client_csid
@@client_csname
@@cmpstate
@@connections
@@cpu_busy
@@curloid
@@datefirst
@@dbts
@@error
@@errorlog
@@failedoverconn
@@guestuserid
@@hacmpservername
@@haconnection
@@heapmemsize
@@identity
@@idle
@@invaliduserid
@@io_busy
@@isolation
@@kernel_addr
@@kernel_size
@@langid
@@language
@@lock_timeout
@@maxcharlen
@@maxgroupid
@@maxpagesize
@@maxspid
@@maxsuid
@@maxuserid
@@max_connections
@@max_precision
@@mempool_addr
@@mingroupid
@@minspid
@@minsuid
@@minuserid
@@min_poolsize
@@monitors_active
@@ncharsize
@@nestlevel
@@nodeid
@@options
@@packet_errors
@@pack_received
@@pack_sent
@@pagesize
@@parallel_degree
@@probesuid
@@procid
@@recovery_state
@@rowcount
@@scan_parallel_degree
@@servername
@@shmem_flags
@@spid
@@sqlstatus
@@ssl_ciphersuite
@@stringsize
@@tempdbid
@@textcolid
@@textdbid
@@textobjid
@@textptr
@@textptr_parameters
@@textsize
@@textts
@@thresh_hysteresis
@@timeticks
@@total_errors
@@total_read
@@total_write
@@tranchained
@@trancount
@@transactional_rpc
@@transtate
@@unicharsize
@@version
@@version_as_integer
livefordie 回复于：2005-04-21 14:35:07
我正想了解这方面的内容，变量这么多，怎么知道它们对应的都是什么意思？
hobbylu 回复于：2005-04-21 14:53:57
你可以自己去判断,去select看什么东西
gsx 回复于：2005-04-22 14:37:00
蠻有用的文件,謝謝囉,馬上去試試
fbirds 回复于：2005-05-25 10:45:18
8) 很不错的东西,谢谢楼主啦!:)
jys1059 回复于：2005-05-25 13:40:37
如何执行这些全局变量，我执行后显示如下
1> select @@version_number
2> go
Msg 137, Level 15, State 2:
Line 1:
Must declare variable '@@version_number'.
hobbylu 回复于：2005-05-25 14:30:43
你的版本估计比较低,这个是12.5版本以上的
关闭本页
|
|
|
|
|
|
|
|
|
|
