which datatype we can choose for ProductCost

Posted by Ramakrishna188 under Sql Server on 5/26/2012 | Points: 10 | Views : 838 | Status : [Member] | Replies : 9
hi all,
I have table called tbl_ClientProducts in this table i have 8 columns, one column name is ProductCost which datatype we select for ProductCost. In my Onlineshopping project i have requirement to compare ProductCost values and dispaly images based on the productcost. Please send me.
Thankyou.




Responses

Posted by: Zeeshan on: 5/26/2012 [Member] Starter | Points: 25

Up
0
Down
float or numeric data type you can use

Worm Regards,
Zeeshan Ansari
Sr. dotnet Trainer

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santhiram on: 5/26/2012 [Member] Starter | Points: 25

Up
0
Down
Better to use "Decimal" datatype for Price related columns.

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 6/3/2012 [Member] Starter | Points: 25

Up
0
Down
U CAN USE DECIMAL DATATYPE


REGARDS


sriram

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ajay.Kalol on: 6/4/2012 [Member] Starter | Points: 25

Up
0
Down
You can use Decimal, float, Numeric Datatype for that.

Ajay
ajaypatelfromsanthal.blogspot.in

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sivakumar.S on: 6/4/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

You can use exact datatypes like Numeric and Decimal for product cost to compare the values. Adding this, you cannot use the float and real data types (which is approximate data types) to compare.


siva

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Pandians on: 6/4/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can use either DECIMAL or NUMERIC data type.

Both are functionally equivalent.

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/15/2012 [Member] Bronze | Points: 25

Up
0
Down
Use Money datatype.

please refer this link
http://msdn.microsoft.com/en-us/library/ms179882.aspx

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 6/15/2012 [Member] Bronze | Points: 25

Up
0
Down
Mark as Answer if its helpful to you

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Calvert on: 6/25/2012 [Member] Starter | Points: 25

Up
0
Down
In data type Event-driven model is another important reason to use objects of arbitrary classes. If data objects implement I Notify Property Changed interface, the grid subscribes to events of this object.
http://www.dapfor.com/en/net-suite/net-grid/tutorial/data-types

Ramakrishna188, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response