UFN_CURRENCY_GETPROPERTIES
Returns information necessary for formatting a value as currency.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENCYID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_CURRENCY_GETPROPERTIES
(
@CURRENCYID uniqueidentifier
)
returns table
as
return
(
select
CURRENCY.ID,
CURRENCY.NAME,
CURRENCY.ISO4217,
CURRENCY.DECIMALDIGITS,
CURRENCY.CURRENCYSYMBOL,
CURRENCY.ROUNDINGTYPECODE,
CURRENCY.SYMBOLDISPLAYSETTINGCODE
from
dbo.CURRENCY
where
CURRENCY.ID = @CURRENCYID
)