•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 397,626 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,409 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 913 | Replies: 1
•
•
Join Date: Jul 2005
Location: Dallas, TX
Posts: 481
Reputation: 
Rep Power: 4
Solved Threads: 19
Posting Pro in Training
This isn't a problem as I have already solved the problem, just trying to figure out why it happened.
Ok I have a field that is type money. I wrote a stored procedure that updates this field, however, I made the datatype for the parameter to get passed in a decimal instead. It was working fine for a while in the development environment. Then we restored the dev from a backup of production. I created the stored procedure the same as it was before, but now it is rounding off the field to the nearest whole number? I'm guessing it is a setting somewhere, but I can't imagine what.
Any ideas?
Like I said, this isn't an emergency, because I've already fixed it by changing the parameter in the stored proc to a money
Ok I have a field that is type money. I wrote a stored procedure that updates this field, however, I made the datatype for the parameter to get passed in a decimal instead. It was working fine for a while in the development environment. Then we restored the dev from a backup of production. I created the stored procedure the same as it was before, but now it is rounding off the field to the nearest whole number? I'm guessing it is a setting somewhere, but I can't imagine what.
Any ideas?
Like I said, this isn't an emergency, because I've already fixed it by changing the parameter in the stored proc to a money
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Threaded Mode- Decimal seperator - thousand seperator when using sql server (MS SQL)
- what is the easiest to use database software? (Database Design)
- class (C++)
- Program help please (C)
- c# or vb.net - how earn more? (C#)
- U$ 100.000.00 For Who Answer This Simple Question: (Java)
- My 1st C++ program advice needed (C++)
- c++ code help (C++)
- banking program -- weird numbers ...??? (C++)
- Double values with two decimal places (C++)
Other Threads in the MS SQL Forum
- Previous Thread: database design
- Next Thread: Particular update
