[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