Posted by Tom Moreau on 03/07/06 22:14

Try:

create proc MyProc
(
@parm1 int -- mandatory
, @parm2 int = 5 -- optional
)
as
....

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

"CK" <c_kettenbach@hotmail.com> wrote in message
news:sBlPf.43261$F_3.25017@newssvr29.news.prodigy.net...
I want the procedure to check for the existence of a paramter and if it is
there, it will process these instructions, otherwise it will process these
instructions. Any ideas? Thanks for your advice.

Regards,
CK

• Next in forum: Re: Can a stored procedure parameter be optional
• Prev in forum: Re: ORDER BY in VIEW not working
• Thread view: Re: Can a stored procedure parameter be optional

[Reply to this message]