問(wèn)題描述
DBCC 命令應(yīng)該叫什么?DBCC 過(guò)程還是 DBCC 函數(shù)?
What should be the DBCC commands be called ? DBCC procedure or DBCC function?
這是令人困惑的，因?yàn)?code>DBCC PAGE 可以在沒(méi)有前綴EXEC 語(yǔ)句的情況下執(zhí)行，很像存儲(chǔ)過(guò)程.但是 EXEC DBCC PAGE(1,1,1,3) 拋出錯(cuò)誤
It is confusing because DBCC PAGE could be executed without prefixing a EXEC statement much like stored procedures. But EXEC DBCC PAGE(1,1,1,3) throws an error
語(yǔ)法錯(cuò)誤 - 關(guān)鍵字 'DBCC' 附近的 Msg 156 語(yǔ)法不正確
Syntax error - Msg 156 Incorrect syntax near the keyword 'DBCC'
它不是函數(shù)，因?yàn)楹瘮?shù)調(diào)用必須在SELECT中進(jìn)行，而是
And it isn't a function because function calling must be made in SELECT, but
SELECT DBCC PAGE(1,1,1,3)
顯示相同的錯(cuò)誤.
推薦答案
據(jù)我所知，DBCC 代表 Data-Base-Console-Command.因此，DBCC 本身既不是過(guò)程也不是函數(shù).它只是一個(gè)你回想起來(lái)的控制臺(tái).
As far as I know DBCC stands for Data-Base-Console-Command. Therefore, DBCC by its self is neither a procedure nor a function. It is simply a console that you recall.
這篇關(guān)于DBCC 命令是存儲(chǔ)過(guò)程還是函數(shù)?的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！