[freetds] Specify decimal scale/precision for output parameter
Konrad J Hambrick
konrad at payplus.com
Thu Aug 27 10:58:24 EDT 2009
Damien Churchill wrote:
> I was wondering how you would specify the scale/precision for an
> output parameter of a RPC call that is null to begin with, since if
> you don't currently it just uses decimal(38,0) which looses everything
> trailing the decimal point.
>
> Any one know how??
Damien --
Maybe use COALESCE( TheField, CAST( 0 as DECIMAL( L,P ))) ?
HTH
-- kjh
More information about the FreeTDS
mailing list