Stored Procedures

Results 1 to 2 of 2

Thread: Stored Procedures

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedures

    I am trying to pass values to a stored procedure. How do I pass optional values? I mean, I donot want to pass optional values to the procedure. Is there any way this can be done?<BR>For example, say, there is a procedure ADD(a,b,c) and I want to pass only a and c but not b. How can I do it?<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default NOT an ASP question...

    ...please post questions like this in the DB forum<BR><BR>try this<BR><BR>create proc IWillNotPostInTheWrongForumAgain<BR>(<BR>@a int = Null<BR>@b int = Null<BR>@c int = Null<BR>)<BR>...<BR>...<BR><BR><BR>so if you do not pass anything it will take it as null.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts