Skip to Content.
Sympa Menu

freetds - Re: [freetds] Specify decimal scale/precision for output parameter

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Konrad J Hambrick <konrad AT payplus.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Specify decimal scale/precision for output parameter
  • Date: Thu, 27 Aug 2009 09:58:24 -0500



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




Archive powered by MHonArc 2.6.24.

Top of Page