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 |
|
raky
Aged Yak Warrior
767 Posts |
 Posted - 2008-01-10 : 00:04:31
|
| Hi, i want to know is there any difference b/w money,numeric,decimal datatypes in sql server 2005 and does text datatype exists in sql server 2000 or not? plz don't say to go through BOL because i had already read BOL for these and i don't find any diff. b/w numeric and decimal.please let me know the diff. b/w money,numeric,decimal datatypes in sql server 2005 thanks in advance............. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2008-01-10 : 00:35:55
|
| decimal/numeric are same. money is very similar with these differences -- precision is fixed to 4 digits to right of decimal (decimal, u specify how many) and range is from -2^63 to 2^63 whereas decimal range is from 10^38 +1 through 10^38 –1yes text data type exists in 2000. of course, everything i just told u, you already saw in BOL.short answer: decimal = numeric, and money is functionally equivelant, but with differences pointed out above. |
 |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-01-10 : 00:42:20
|
quote:
Originally posted by russell
decimal/numeric are same. money is very similar with these differences -- precision is fixed to 4 digits to right of decimal (decimal, u specify how many) and range is from -2^63 to 2^63 whereas decimal range is from 10^38 +1 through 10^38 –1yes text data type exists in 2000. of course, everything i just told u, you already saw in BOL.short answer: decimal = numeric, and money is functionally equivelant, but with differences pointed out above.
thanks |
|
|
|
|
|
|
|
|
plz go through this.........