Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2005-04-03 : 14:20:06
|
| I want to store prices in Euro in my Database and then access them through asp.net application.Is there any special way of using euro currency in the DB or should I simply use a 'money' column.thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-03 : 14:48:07
|
| Money is the perfect datatype. Your computer's regional settings will determine if it uses the euro symbol when formatting currency values. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-04-03 : 15:02:30
|
| As far as storage is concerned it's just a value. You might want to hold a currency attribute but not as part of the value.What is displayed to the client ca be formatted at the presentation layer.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-04-03 : 17:17:42
|
| ThanksActually, in my application, I want to display prices in 2 currencies, £ & €. So no matter if the user coming from UK or France, they should see both prices |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-04-04 : 08:21:24
|
| "display prices".....ideal for PRESENTATION LAYER.Given that the £->€ rate changes daily, you should establish a price per object in BASE currency and save this within your database (along with relevent CCY Code)....and use a lookup table (of CCY-pair exchange rates) to determine what price an object is in an alternative PAYMENT currency. This would allow you expand beyond 2 limited CCY's. |
|
|
|
|
|
|
Working with Euro