hzxl
发贴: 169
积分: 40
|
于 2003-08-31 19:36
SQLSERVER内部函数汇总:
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 of' sELECT @@IDENTITY AS 'Identity' sELECT @@IDLE AS 'Idle ms', GETDATE() AS 'As of' SELECT @@IO_BUSY AS 'IO ms', GETDATE() AS 'As of' 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 of' SELECT @@TOTAL_READ AS 'Reads', @@TOTAL_WRITE AS 'Writes', GETDATE() AS 'As of' SELECT @@TOTAL_READ AS 'Reads', @@TOTAL_WRITE AS 'Writes', GETDATE() AS 'As of' select @@TRANCOUNT SELECT @@VERSION select @@FETCH_STATUS
内部变量:
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
|