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 |
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-11-10 : 03:05:46
|
I have a column which stores values like thisCol1.95.95 .88.55The max value that column will store is 1.00, most of the times it will be like the data above. Considering this what could be the best data type to store these kind of values? Its just for the record sake and I dont do any manipulation using this column. I was thinking about using varchar(5)Any Suggesstions?ThanksKarunakaran |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-11-10 : 03:48:59
|
If no maninulation will be perform or what so ever on that column, you can use varchar.If the value is only numbers with decimal no alpha, why not use numeric(3,2)[KH] |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-11-10 : 04:05:10
|
ThanksKarunakaran |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-10 : 05:46:50
|
>>I dont do any manipulation using this column.Then, why do you need that column?MadhivananFailing to plan is Planning to fail |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2005-11-10 : 09:06:53
|
quote: Originally posted by madhivanan >>I dont do any manipulation using this column.Then, why do you need that column?MadhivananFailing to plan is Planning to fail
Because it comes from an external file, I have to keep that column cant avoid it.ThanksKarunakaran |
|
|
|
|
|