Hi, Hope the following stuff helps you. Decimal is suggested in your case. In SQL Server, the numeric and decimal data types are equivalent. Both data types let you store integers that have up to 38 digits. The syntax for defining a decimal data type is:
DECIMAL[(p[, s])] The first number after the DECIMAL keyword is the precision setting, which defines the total number of digits the integer can have. The second number is the scale setting, which defines the total number of digits to the right of the decimal place. For example, in the statement DECLARE @MyLargeNumber DECIMAL(20, 0) @MyLargeNumber is an integer that has 20 digits because the scale is equal to 0. *. . .* Thanks, Siva On Nov 30, 2007 12:49 PM, thiruselvan <[EMAIL PROTECTED]> wrote: > > Guys, > > I want to know in sql server 2005, what is the > maximum datatype available for storage.i am already using money which > stores 15 digits.Anyone can tel me more than money,so i will be able > to store 30 digits. > > Thanks > thiru > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups ".NetIndia" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/TechdotNetIndia?hl=en http://www.satheeshbabu.com http://www.satheeshbabu.blogspot.com/ -~----------~----~----~----~------~----~------~--~---
