Procedure or function 'sp_***' expects parameter '@', which was not supplied

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

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.

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

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 :)

Posted 19-Dec-12 5:49am

Joy1979

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 9581488 · Accepted Answer · 2012-12-19T05:55:00

Solution 1

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

exec SP_DELETE_DESIGN_PARAMETERS 111

Posted 19-Dec-12 5:55am

Member 9581488

Comments

Joy1979 19-Dec-12 12:01pm

Thanks for help. I have 1000 rows in Design_ID column and If I need to display entire data should I use : exec SP_DELETE_DESIGN_PARAMETERS @DESIGN_ID only? Please advise.

Member 9581488 19-Dec-12 12:12pm

Your stored procedure is deleting record when you pass @DESIGN_ID.
if you want to display data then you should use select query to return the result after deleting particular row from the table.

Procedure or function 'sp_***' expects parameter '@', which was not supplied

1 solution

Solution 1

Add your solution here

Preview 0

Procedure or function 'sp_***' expects parameter '@', which was not supplied

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us