sql中的小澄清...执行 [英] small clarification..execution in sql

问题描述

我有存储过程sp_class意思是

 sp_class 

'如果执行这个



命令已成功完成。



会发生什么...如果只执行存储过程的名称

解决方案

取决于存储过程的设计目的。由于它不是标准的SQL SP，我们无法告诉你它的作用 - 但是即使你编写它来获取参数并执行一些特定的任务，例如插入表中它仍然可以做一些事情，只要你允许参数为null（或者为它们提供默认值）。



所以在SSMS中查看你的数据库，并检查SP。看看它做了什么 - 因为我们可以;从这里做到这一点！ ：笑：

I have stored procedure sp_class mean

sp_class

'if execute this

Command(s) completed successfully.

what will happen.. if only execute the name of the stored procedure

解决方案

Depends on what the stored procedure is designed to do. Since it isn't a standard SQL SP, we can't tell you what it does - but even if you wrote it to take parameters and do some specific task such as insert into a table it can still do something provided you have allowed the parameters to be null (or provided defaults for them).

So look at your database in SSMS, and examine the SP. See what it does - becasue we can;t do that from here! :laugh:

这篇关于sql中的小澄清...执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！