2nd SQL-functions for the conversion of a number of wor

Affiliates: 0,19 $how to earn
Pay with:
i agree with "Terms for Customers"
Sold: 1 last one 17.02.2012
Refunds: 0

Uploaded: 13.02.2012
Content: numtostr_sql.rar 2,55 kB
Loyalty discount! If the total amount of your purchases from the seller VSbest more than:
10 $the discount is10%
show all discounts
3 $the discount is3%
If you want to know your discount rate, please provide your email:

Seller

VSbest information about the seller and his items
offlineAsk a question

Seller will give you a gift certificate in the amount of 28,656 RUB for a positive review of the product purchased.

Product description

SQL Scripts are implemented as two functions:

1. translation of any integer number in the number of words

2. The transfer of funds among the words


Maximum integer value for translation: 999 999 999 999 999 (999 trillion, etc.)


When transferring sums of money added to the desired shape (ruble / ruble / rubles and kopecks / cents / pennies).


Examples of use:

1) ten million. One thousand four hundred and eighty. Ninety-three

2) nine hundred ninety-nine trillion nine hundred ninety-nine billion nine hundred ninety-nine million nine hundred ninety-nine thousand nine hundred ninety-nine

3) nine thousand one hundred twenty-three rubles one kopeck

4) nine thousand one hundred twenty-three ruble twenty three pennies


The code does not use any new features SQL, so the function will work in the Microsoft SQL Server database with a version of not less than 2,000.


Since the code is open scripts, when necessary, to make any changes (for example to change rubles for euros or EPF) or change to support other databases.

Additional information

2 The archive file functions: in each file in function SQL.

Feedback

0
No feedback yet.
Seller will give you a gift certificate in the amount of 28,656 RUB for a positive review of the product purchased..
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)