Re: Specify decimal scale/precision for output parameter

Konrad J Hambrick <[email protected]> Thu, 27 Aug 2009 09:58:24 -0500

Newsgroups	gmane.comp.db.tds.freetds
Organization	PayPlus Software, Inc
Message-ID	<[email protected]>


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