Get the App
SLTechnology News&Howtos  ›  Database  › 

What are the internal functions of SQLSERVER

Shulou Source: shulou.com Published: 2022-05-31 18:22:49 11月16日 Update

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!

Tags: Function learning content that is ideas situations articles more knowledge knowledge points articles follow questions practice push research verification Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Huawei MariaDB MySQL NVidia