Shulou(Shulou.com)05/31 Report--

This article mainly explains the "SQL Server global variable summary", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "SQL Server global variable summary" bar!

@ @ SERVERNAME: returns the name of the local server running SQL Server 2000.

@ @ REMSERVER: returns the name of the remote SQL Server server recorded in the login record.

@ @ CONNECTIONS: returns the number of connections or attempts to connect since the last time SQL Server was started, which makes it easy for managers to know all the attempts to connect to the server today.

@ @ CURSOR_ROWS: returns the number of eligible rows that currently exist in the last connected and opened cursor.

@ @ ERROR: returns the error code of the last executed Transact-SQL statement.

@ @ ROWCOUNT: returns the number of rows affected by the previous statement, and any statement that does not return a row sets this variable to 0.

@ @ VERSION: returns the date, version, and processor type of SQL Server's current installation.

@ @ CPU_BUSY: returns the working time of CPU in milliseconds since SQL Server was last started.

@ @ DATEFIRST: returns the value of the DATAFIRST parameter assigned using the SET DATEFIRST command. The SET DATEFIRST command is used to specify what day of the week the first day of the week is.

@ @ DBTS: returning the current timestamp value must ensure that the timestamp value in the database is unique.

@ @ FETCH_STATUS: returns the status value of the last FETCH statement.

@ @ IDENTITY: returns the column value of the identity column that was last inserted into the row.

@ @ IDLE: returns the time, in milliseconds, that CPU has been in an empty state since SQL Server was last started.

@ @ IO_BUSY: returns the time (in milliseconds) that CPU has taken to perform input and output operations since SQL Server was last started.

@ @ LANGID: returns the ID value of the language currently in use.

@ @ LANGUAGE: returns the name of the language currently in use.

@ @ LOCK_TIMEOUT: returns the amount of time the current session waits for a lock in milliseconds.

@ @ MAX_CONNECTIONS: returns the maximum number of connections allowed to the SQL Server.

@ @ MAX_PRECISION: returns the accuracy of the decimal and numeric data types.

@ @ NESTLEVEL: returns the nesting level of the currently executed stored procedure, with an initial value of 0.

@ @ OPTIONS: returns information about the current SET option.

@ @ PACK_RECEIVED: returns the number of input packets read by SQL Server over the network.

@ @ PACK_SENT: returns the number of output packets written by SQL Server to the network.

@ @ PACKET_ERRORS: returns the number of errors in network packets.

@ @ PROCID: returns the ID value of the current stored procedure.

@ @ SERVICENAME: returns the service status in which SQLServer is running, such as MS SQLServer, MSDTC, SQLServerAgent.

@ @ SPID: returns the server processing ID value processed by the current user.

@ @ TEXTSIZE: returns the TEXTSIZE option value of the SET statement. The SET statement defines the text or image in the SELECT statement. The basic unit of the maximum length of a data type is bytes.

@ @ TIMETICKS: returns the number of microseconds per clock.

@ @ TOTAL_ERRORS: returns the number of disk read and write errors.

@ @ TOTAL_READ: returns the number of disk reads.

@ @ TOTAL_WRITE: returns the number of disk writes.

@ @ TRANCOUNT: returns the number of active transactions in the current connection.

Thank you for your reading, the above is the content of "SQL Server global variable summary", after the study of this article, I believe you have a deeper understanding of the global variable summary of SQL Server, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.