Re: Optional Output parameters in MS SQL Server.
From: ambshah (ambshah_at_hotmale.not4spam)
Date: 02/16/04
- Next message: david epsom dot com dot au: "Re: Refreshing linked tables"
- Previous message: Alex: "pass large xml file to stored procedure"
- Maybe in reply to: Frank Armstrong: "Re: Optional Output parameters in MS SQL Server."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 16 Feb 2004 22:51:01 +0530
btw.
just add default to the parameters
eg abc varchar(10) = '' will result in the parameter becoming optional.
like in vb you cant ignore the parameter and supply value for the next one
..
hth any other user hoping for an answer
"Rekhender Dhawan" <rekhender@softhome.net> wrote in message
news:eOAmgl#5DHA.1816@TK2MSFTNGP12.phx.gbl...
> Dear All,
>
> I have actually ported an application from Interbase DB to MS Sql Server.
> But now the SP written in it needs to have optional output parameters, any
> idea how can i do this? The SP are ready and working, but need to make
then
> optional, other wise i need to change lot of source unneccesaarly.
>
> Thanks in advance
> Rekhender
>
>
- Next message: david epsom dot com dot au: "Re: Refreshing linked tables"
- Previous message: Alex: "pass large xml file to stored procedure"
- Maybe in reply to: Frank Armstrong: "Re: Optional Output parameters in MS SQL Server."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
