Hey All,
Ok, I believe I've always used int(4) in the past but was curious if I should be using numeric or something else...my values will be a number and most like 4-5 in length. I will need to be able to sum and multiply, etc. with this field...what do you recommend?
SQL2000
Numeric data consists of numbers only. Numeric data includes positive and negative numbers, decimal and fractional numbers, and whole numbers (integers).
Integer data consists of negative or positive whole numbers.
In SQL Server, the numeric data type is equivalent to the decimal data type.
jmurrayhead
If you agree, give me rep. If my post helped you, click "Thanks".
If you like it here...throw us a few bones to help support us.
Ok, then I'll stay with int because for the most part it will be positive whole numbers and maybe down the line negative but very unlikely. Its for a headcount of employees in locations, grade, etc.
Unless you need fractional results, use integer -- numeric/decimal is for exact representation of non-whole numbers. The minimum storage requirement for numeric is 5-bytes, and goes up to 17-bytes and the Precision increases whilst integer is a mere 4-bytes.
Wolffy
------------------------
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Rework for your specific environment may be required. Void where prohibited by law. Not valid in California. Your mileage may vary.
no fractions...thank goodness. have you ever used bigint(8)?
Just out of interest, how would you have a negative head count at a location? Did someone lose their head?Originally Posted by Rebelle
ok..ok...i guess you wouldn't.Just out of interest, how would you have a negative head count at a location? Did someone lose their head?
I will have another field (money) that I will divide by the sum of the field (int)4...
revenue/sumIntField(s) to display a value in ASP.
I have used bigint, but only for numbers that I expect might exceed the limit of the int datatype (The limit is -2,147,483,648 to 2,147,483,647). Otherwise, int is a much better choice because the amount of storage required is less than a bigint.
"The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS
Posting Permissions 
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks