Re: error executing sprocedure

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/02/04 

Date: Mon, 2 Aug 2004 08:14:22 -0400

In addition to Jacco's comments, what he and others showed you is an
optional parameter... To make a parameter optional you must give it a
default value. Then when no value is supplied by the caller the default
value is used.

You may use default values with OUTPUT parameters. And you may have some,
all or none of your parameters with default values. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@discussions.microsoft.com> wrote in message
news:8edb01c47878$887871e0$a501280a@phx.gbl...
Hello,
I've created one stored procedure that has one input
parameter(number of days), if i donīt pass any value when
executing this procedure sql reports one error.
I would like to execute this procedure and don't pass the
input paramenter to the stored procedure but if the number
of days is 0(zero)
Is this possible?
Thanks.
Best regards

Relevant Pages

  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Calling remote Stored Procedures
    ... I am experiencing some difficulties when it comes to executing a SQL ... Stored procedure on a remote SQL server. ... When I try to execute the Stored Procedure 'Ten Most Expensive ...
    (microsoft.public.sqlserver.server)
  • Re: Limitations of Scheduled jobs
    ... > Actually we can schedule the jobs with accuracy less than ... where executing the stored procedure ... >>on what the stored procedure does exactly. ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • RE: Login failed for user foo but the SQL executed correctly
    ... Could you post the detailed error message when executing the stored ... and see under which user the stored procedure is executed. ... Is the error thrown by the stored procedure or the SQL Server 2000? ... | for user 'foo' error. ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
Quantcast