sale quantity is use what data type???

_{Wednesday, December 21, 2011 8:49 AM}

the sale quantity is use what data type??? 

Developing is part of being a developer.

_{Wednesday, December 21, 2011 8:54 AM ✅Answered}

It could be DECIMAL datatype as wellBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

_{Wednesday, December 21, 2011 9:21 AM ✅Answered}

Yes.
You can change it according to your requirement.

DECIMAL(5,2) Means == 100.34
DECIMAL(6,2) Means == 1000.34
DECIMAL(6,2) Means == 1000.343Shatrughna.

_{Wednesday, December 21, 2011 8:53 AM}

SaleQuantity should be int.Any issue ??

Shatrughna.

_{Wednesday, December 21, 2011 9:04 AM}

It could be DECIMAL datatype as well Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

In the SQL server data type automatic choose decimal(18, 0) , its changeable?Developing is part of being a developer.