c# - SQL 2000: Stored Procedures Error : Procedure or Function 'name' expects parameter '@param', which was not supplied -

I have a stored procedure that has been declared as:

  ALTER PROCEDURE dbo.thisProc @ID Int, @TypeId, DOSID Int, @ special varchar (10)  

What do I need to do:

If the @ID supply If ID is not supported with block, then block a special execution, if the check is typed, type type is IP input and then execute the block one by one I

I do not want to write multiple SQL queries to deal differently

thanks.

Sample code:

  Creating process is not @ id as GoArticle @ID int, @ DoTypeID int, @DocID int, @Sec varchar (10) And, @Doctorate is not zero and @SE = 'Inner' start "My question is here" where the article is. ID = ID and graph. = @DOCID END If IID is zero and @DocID is zero and @Sec = 'list' is BEGINEXEC GetDocList @DocTypeID END if IID is zero and @DocID is zero and @Sec = 'full' BEGINEXEC GetDocList @DocTypeID END < / Code> 

Just assign a default value zero E.g.

  @id int = null