Chapter 6 PROGRAMMING SQL SERVER 2000 341 Global
Chapter 6 PROGRAMMING SQL SERVER 2000 341 Global Variable Function @@IDENTITY Returns the value used for the last INSERT INTO an identity column for the current connection. @@IDLE Returns the time in milliseconds that SQL Server has been idle since the last restart. @@IO_BUSY Returns the time in milliseconds that SQL Server has spent waiting for IO to return from a read or write request. @@LANGID Returns the language identifier of the current language in use. @@LANGUAGE Returns the name of the language currently in use, which is probably more useful than the ID number. @@LOCK_TIMEOUT Returns the number of milliseconds that the current connection will wait for a lock to clear to complete its work. @@MAX_CONNECTIONS The maximum number of simultaneous user connections allowed on the current SQL Server. @@MAX_PRECISION The precision used by the DECIMAL and NUMERIC data types on the server. By default, this is 38. @@NESTLEVEL The current nesting level during stored procedure execution. (See Chapter 9.) @@OPTIONS Returns an integer representing the settings of the user options for the current connection. (See User Options, later in this chapter.) @@PACK_RECEIVED The number of network packets received by the SQL Server since it was last restarted. @@PACK_SENT The number of packets sent by the SQL Server since it was last restarted. @@PACKET_ERRORS The number of packet errors that the SQL Server has seen since it was last restarted. @@PROCID The stored procedure identifier of the currently executing stored procedure. @@REMSERVER Returns the name of the SQL Server running the remote stored procedure. @@ROWCOUNT Returns the number of rows returned by the last statement. (See Using @@ROWCOUNT, later in this chapter.) @@SERVERNAME Returns the name of the current server. continues
For high quality java hosting services please check java web hosting website.