What are the internal functions of SQLSERVER
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!