Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Which data type to use ??

Status
Not open for further replies.
yaya013

yaya013

Programmer
Jun 4, 2003
53
IL
Hello,

I use SQL Server 2000
What is the correct data type to hold money ?

I know that money date type is not recommended.

Thank you .
Yair
 
Sort by date Sort by votes
I tend to hold it as a decimal to 2 dps
That's just dealing with Sterling and Euros and hasn't caused any problems
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
894
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
1K
Chris Miller
Chris Miller
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
Jago11
  • Locked
  • Question
When to use 1=1 logic 1
Replies
7
Views
456
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top