Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 Smile | :)
Posted 19-Dec-12 6:49am
Joy1979316

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

exec SP_DELETE_DESIGN_PARAMETERS (pass your @DESIGN_ID here)
for exp:
 
exec SP_DELETE_DESIGN_PARAMETERS 111
  Permalink  
Comments
Joy1979 at 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 at 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.

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

  Print Answers RSS
0 BillWoodruff 300
1 Mathew Soji 274
2 Afzaal Ahmad Zeeshan 268
3 DamithSL 225
4 Sergey Alexandrovich Kryukov 205
0 OriginalGriff 6,249
1 Sergey Alexandrovich Kryukov 5,853
2 DamithSL 5,183
3 Manas Bhardwaj 4,673
4 Maciej Los 3,865


Advertise | Privacy | Mobile
Web04 | 2.8.1411019.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100