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

This article mainly explains "what are the internal functions of SQLSERVER". The content of the explanation is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the internal functions of SQLSERVER"?

What are the internal functions of SQLSERVER

Select@@CONNECTIONS

Select@@CURSOR_ROWS

Select@@DATEFIRST

SELECT@@DBTS

Select@@ERROR

Select@@rowcount

Select@@FETCH_STATUS

SELECT@@CPU_BUSYAS'CPUms',GETDATE () AS'Asof'

SELECT@@IDENTITYAS'Identity'

SELECT@@IDLEAS'Idlems',GETDATE () AS'Asof'

SELECT@@IO_BUSYAS'IOms',GETDATE () AS'Asof'

SELECT@@LANGIDAS'LanguageID'

SELECT@@LANGUAGEAS'LanguageName'

SELECT@@LOCK_TIMEOUT

SELECT@@MAX_CONNECTIONS

SELECT@@MAX_PRECISION

Select@@NESTLEVELAS'InnerLevel'

What are the internal functions of SQLSERVER

Select@@OPTIONS

SELECT@@PACKET_ERRORS

SELECT@@PACK_RECEIVED

SELECT@@PACK_SENT

SELECT@@PROCIDAS'ProcID'

SELECT@@REMSERVER

SELECT@@SERVERNAME

SELECT@@SERVICENAME

SELECT@@SPID

SELECT@@TEXTSIZE

SETTEXTSIZE2048

SELECT@@TEXTSIZE

SELECT@@TIMETICKS

SELECT@@TOTAL_ERRORSAS'Errors',GETDATE () AS'Asof'

SELECT@@TOTAL_READAS'Reads',@@TOTAL_WRITEAS'Writes',GETDATE () AS'Asof'

SELECT@@TOTAL_READAS'Reads',@@TOTAL_WRITEAS'Writes',GETDATE () AS'Asof'

Select@@TRANCOUNT

SELECT@@VERSION

Select@@FETCH_STATUS

Thank you for your reading, these are the contents of "what are the internal functions of SQLSERVER". After the study of this article, I believe you have a deeper understanding of what the internal functions of SQLSERVER have, 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.