CODEWITHSUNDEEP
sqlsql-serverdatabasesql-server-2005t-sql
Paresh
Paresh

Reputation: 3749

data storage limitation issue

I face one problem, one column is i have taken as numeric(38,0)

Data stored in this column is going out of range, means it is reach it's storage limitation. i have tried with also bigint , but facing same problem.i can not take it as varchar because i have to use in another calculation so at that time i must need to convert it from varchar to bigint ot numeric(38,0).

So, is there any solution to store high range value.

Upvotes: 0

Views: 87

Answers (1)

Andomar
Andomar

Reputation: 238086

A float can handle really big numbers. The most precise float is a float(53) with 15 digit precision.

Upvotes: 1

Related Questions