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
Delete From Design_Parameters where Design_ID = @DESIGN_ID
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
exec SP_DELETE_DESIGN_PARAMETERS (pass your @DESIGN_ID here)
exec SP_DELETE_DESIGN_PARAMETERS 111
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)