SQL Command parameters

  • Thread starter Thread starter Ryan Wade
  • Start date Start date
R

Ryan Wade

using SQL Server 2000, when I execute a SP through the sqlcommand, if I
don't declare all the input and output parameters, it crashes. Is there
anyway to give it only the parameters I need and execute?
 
Hi

set all parameted to take default values.
LIKE THIS:
CREATE PROCEDURE P1
@OID varchar(8000) = null
RETURN
GO

HTH
Ravikanth[MVP]
 
How are you calling the stored procedure? I wrote an article that might
help. See http://www.betav.com/msdn_magazine.htm

hth

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top