问题描述
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 语法不正确
它不是函数，因为函数调用必须在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 命令是存储过程还是函数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！