日本综合一区二区|亚洲中文天堂综合|日韩欧美自拍一区|男女精品天堂一区|欧美自拍第6页亚洲成人精品一区|亚洲黄色天堂一区二区成人|超碰91偷拍第一页|日韩av夜夜嗨中文字幕|久久蜜综合视频官网|精美人妻一区二区三区

SQL SERVER內(nèi)部函數(shù)是SQL數(shù)據(jù)庫中非常重要的一類函數(shù)，下面就為您介紹SQL SERVER內(nèi)部函數(shù)，如果您對此方面感興趣的話，不妨一看。

鹽亭網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)建站,鹽亭網(wǎng)站設(shè)計制作，有大型網(wǎng)站制作公司豐富經(jīng)驗。已為鹽亭千余家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\外貿(mào)網(wǎng)站制作要多少錢，請找那個售后服務(wù)好的鹽亭做網(wǎng)站的公司定做！

SQL SERVER內(nèi)部函數(shù)：

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調(diào)用Sql Server存儲過程

SQL Server創(chuàng)建視圖的語法

SQL Server排序規(guī)則的應(yīng)用

帶您了解SQL Server標(biāo)識列

當(dāng)前題目：SQLSERVER內(nèi)部函數(shù)大全
標(biāo)題網(wǎng)址：http://www.dlmjj.cn/article/dppcjhe.html