which datatype we can choose for ProductCost

Posted by Ramakrishna188 under Sql Server on 5/26/2012 | Points: 10 | Views : 1902 | Status : [Member] | Replies : 9

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

0	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

Latest Posts