CODEWITHSUNDEEP
sql-server
JAX
JAX

Reputation: 1620

SQL Server datatype for very large numbers

In SQlite, if we use the datatype Real, we can store numbers such as 2E200 or 5E10, but when I use the Real datatype in SQL Server, it doesn't let me store numbers of that kind, so what is the datatype that I can use for that purpose. (of course nothing String or Char type, this is a number which means 2*10^200 or 5*10^10)

Upvotes: 0

Views: 2243

Answers (2)

Susanna
Susanna

Reputation: 72

Maybe, float(53) is what you're looking for:
http://technet.microsoft.com/it-it/library/ms173773.aspx

Upvotes: 1

Techie Joe
Techie Joe

Reputation: 867

You'll want to consult this MSDN article to see what would work best for you. I've used nvarchar before because I had needs for importing from many and various non-windows sources.

Upvotes: 0

Related Questions