問題描述
DBCC 命令應該叫什么?DBCC 過程還是 DBCC 函數?
What should be the DBCC commands be called ? DBCC procedure or DBCC function?
這是令人困惑的，因為DBCC PAGE 可以在沒有前綴EXEC 語句的情況下執行，很像存儲過程.但是 EXEC DBCC PAGE(1,1,1,3) 拋出錯誤
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
語法錯誤 - 關鍵字 'DBCC' 附近的 Msg 156 語法不正確
Syntax error - Msg 156 Incorrect syntax near the keyword 'DBCC'
它不是函數，因為函數調用必須在SELECT中進行，而是
And it isn't a function because function calling must be made in SELECT, but
SELECT DBCC PAGE(1,1,1,3)
顯示相同的錯誤.
推薦答案
據我所知，DBCC 代表 Data-Base-Console-Command.因此，DBCC 本身既不是過程也不是函數.它只是一個你回想起來的控制臺.
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.
這篇關于DBCC 命令是存儲過程還是函數?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！