SQL SERVER内部函数大全

数据库 SQL Server
SQL SERVER中的函数非常多,下文为您整理了SQL SERVER中的内部函数,希望可以对您学习SQL SERVER数据库能有所帮助。

SQL SERVER内部函数是SQL数据库中非常重要的一类函数,下面就为您介绍SQL SERVER内部函数,如果您对此方面感兴趣的话,不妨一看。

SQL SERVER内部函数:

select @@CONNECTIONS

select @@CURSOR_ROWS

select @@DATEFIRST

SELECT @@DBTS

select @@ERROR

select @@rowcount

select @@FETCH_STATUS

SELECT @@CPU_BUSY AS 'CPU ms', GETDATE() AS 'As of'

sELECT @@IDENTITY AS 'Identity'

sELECT @@IDLE AS 'Idle ms', GETDATE() AS 'As of'

SELECT @@IO_BUSY AS 'IO ms', GETDATE() AS 'As of'

SELECT @@LANGID AS 'Language ID'

SELECT @@LANGUAGE AS 'Language Name'

SELECT @@LOCK_TIMEOUT

SELECT @@MAX_CONNECTIONS

SELECT @@MAX_PRECISION

select @@NESTLEVEL AS 'Inner Level'

select @@OPTIONS

SELECT @@PACKET_ERRORS

SELECT @@PACK_RECEIVED

SELECT @@PACK_SENT

SELECT @@PROCID AS 'ProcID'

SELECT @@REMSERVER

SELECT @@SERVERNAME

SELECT @@SERVICENAME

SELECT @@SPID

SELECT @@TEXTSIZE

SET TEXTSIZE 2048

SELECT @@TEXTSIZE

SELECT @@TIMETICKS

SELECT @@TOTAL_ERRORS AS 'Errors', GETDATE() AS 'As of'

SELECT @@TOTAL_READ AS 'Reads', @@TOTAL_WRITE AS 'Writes', GETDATE() AS 'As of'

SELECT @@TOTAL_READ AS 'Reads', @@TOTAL_WRITE AS 'Writes', GETDATE() AS 'As of'

select @@TRANCOUNT

SELECT @@VERSION

select @@FETCH_STATUS


 

 

【编辑推荐】

SQL Server变量赋值的方法

Java调用Sql Server存储过程

SQL Server创建视图的语法

SQL Server排序规则的应用

带您了解SQL Server标识列

责任编辑:段燃 来源: 互联网
相关推荐

2010-11-08 17:07:41

SQL Server字

2010-09-27 16:19:37

SQL Server时

2010-11-09 13:47:17

SQL Server资

2010-11-12 11:07:03

sql server内

2018-12-26 16:30:09

SQL Server内部运行机制数据库

2010-06-28 08:37:58

SQL Server

2010-07-22 15:56:04

SQL Server临

2011-09-01 19:00:08

SQL ServerDBCC语句

2010-09-14 14:22:30

Sql Server日

2010-07-12 11:38:24

SQL Server函

2010-10-21 15:21:06

SQL Server系

2010-07-23 13:04:39

SQL Server

2010-07-15 09:14:32

SQL server组

2010-09-27 16:38:19

Sql Server日

2010-07-09 10:08:53

SQL Server函

2010-07-19 11:17:28

SQL Server

2010-11-10 14:35:17

SQL Server创

2010-11-09 11:40:14

SQL Server查

2010-09-06 17:11:14

SQL函数

2010-09-06 16:25:46

SQL函数
点赞
收藏

51CTO技术栈公众号