过程或函数'sp _ ***'需要参数'@'，这是未提供的 [英] Procedure or function 'sp_***' expects parameter '@', which was not supplied

问题描述

您好：



我正在尝试执行存储过程但会出现以下错误：

Hello:

I am trying to execute stored proc but getting following error:

Procedure or function ''SP_DELETE_DESIGN_PARAMETERS'' expects parameter ''@DESIGN_ID'', which was not supplied.

以下是我的存储过程：

我试图在SQL中执行它需要结果表。

Below is my stored proc:
I am trying to execute it in SQL need result in table.

CREATE PROCEDURE SP_DELETE_DESIGN_PARAMETERS

@DESIGN_ID INT

AS

BEGIN

Delete From Design_Parameters where Design_ID = @DESIGN_ID

END

exec SP_DELETE_DESIGN_PARAMETERS

我知道我错过了一些非常简单的观点。我很感激任何帮助。



我在VB.Net上使用SQL2008 R2和VS2010



谢谢：）

I know I am missing some very easy points. I would appreciate any help into this.

I am using SQL2008 R2 and VS2010 with VB.Net

Thanks :)

推荐答案

exec SP_DELETE_DESIGN_PARAMETERS（在这里传递你的@DESIGN_ID）

for exp：



exec SP_DELETE_DESIGN_PARAMETERS 111

exec SP_DELETE_DESIGN_PARAMETERS (pass your @DESIGN_ID here)
for exp:

exec SP_DELETE_DESIGN_PARAMETERS 111

这篇关于过程或函数'sp _ ***'需要参数'@'，这是未提供的的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！