建站
咨詢
售后
建站咨詢
新聞中心
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)識列
網(wǎng)站名稱：SQLSERVER內(nèi)部函數(shù)大全
文章鏈接：http://www.5511xx.com/article/dppcjhe.html
