when i calling stored procedure
can i make one of the output parameter be optional?
not sent the parater to the procedure
Tnx in advanceJust give it a default value of NULL
procname
(
@.p1 INT = NULL OUTPUT
) AS
BEGIN
...
END|||> when i calling stored procedure
> can i make one of the output parameter be optional?
>
sure. just give the parameter a default value e.g.
create procedure dbo.proc
(
@.value varchar(10)=null output
)
as
...
James
Sunday, February 12, 2012
can i make optional OUTPUT paramater?
Labels:
calling,
database,
microsoft,
mysql,
optionalnot,
oracle,
output,
paramater,
parameter,
parater,
procedurecan,
proceduretnx,
server,
sql,
stored
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment