money(2) 
Author Message
 money(2)

To do the migration of a database from version 4.9.2 to 11.5, i'm trying to
recompile stored procedures on the target server, and get an error on
convert (money(2), col ....)

I didn't find in 4.9.x documentation any information about the possibility
to specify a length or scale on a type money, and don't understand the
meaning of this convert.

I made a test to see if the storage size was different but it seems that it
is of 8 bytes for both (money and money(2)).

I don't know how to modify the SP to allow its compilation on 11.5 being
sure that it will not affect the result.

Thanks in advance for your help.

Frederic Hourmant / cast




Mon, 18 Sep 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ==== FREE MONEY FREE MONEY FREE MONEY ======

2. money for no money

3. BUG? Multiplying MONEY by MONEY

4. MAKE MONEY FASTMAKE MONEY FAST

5. oh~~~~~~~~money $$$$$ really money a momnet ~~~!!!

6. Error Msg.: There is insufficient result space to convert a money value to money!!

7. round money

8. Extra Money

9. Save Money On Phone Bill (If In Australia) 6153

10. Access/ SQL Server 'Money' data type

11. DTS import of money field

12. How to display and still sort by money field


 
Powered by phpBB® Forum Software