Sunday, February 12, 2012

can i make optional OUTPUT paramater?

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

No comments:

Post a Comment