SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Numeric / Decimal / Float / Varchar - Whats best?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

karuna
Aged Yak Warrior

581 Posts
Posted - 11/10/2005 :  03:05:46  Show Profile  Send karuna a Yahoo! Message  Reply with Quote
I have a column which stores values like this

Col1
.95
.95
.88
.55
The 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?

Thanks

Karunakaran

khtan
In (Som, Ni, Yak)

Singapore
16745 Posts
Posted - 11/10/2005 :  03:48:59  Show Profile  Reply with Quote
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]
Go to Top of Page

karuna
Aged Yak Warrior

581 Posts
Posted - 11/10/2005 :  04:05:10  Show Profile  Send karuna a Yahoo! Message  Reply with Quote
Thanks

Karunakaran
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22460 Posts
Posted - 11/10/2005 :  05:46:50  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
>>I dont do any manipulation using this column.

Then, why do you need that column?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

karuna
Aged Yak Warrior

581 Posts
Posted - 11/10/2005 :  09:06:53  Show Profile  Send karuna a Yahoo! Message  Reply with Quote
quote:
Originally posted by madhivanan

>>I dont do any manipulation using this column.

Then, why do you need that column?

Madhivanan

Failing to plan is Planning to fail


Because it comes from an external file, I have to keep that column cant avoid it.

Thanks

Karunakaran
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000