CODEWITHSUNDEEP
sql-server-2008
user2575061
user2575061

Reputation:

Having error, Arithmetic overflow error converting numeric to data type numeric

I want to update value in the table's column in sql server which is of type decimal(2,2) and I have used following query to update that

update Bedding
  set Bedroom = 1.0
  where BeddingId = 5

But I am having following error :Arithmetic overflow error converting numeric to data type numeric. Thanks in advance.

Upvotes: 0

Views: 320

Answers (1)

Mike Stotts
Mike Stotts

Reputation: 86

Am column defined as decimal(n,m) holds n decimal digits, m of which are the fraction part. So decimal(2,2) is 2 digits long, both of which are the fraction part. This will only be able to take values in the range -0.99 to 0.99.

Upvotes: 1

Related Questions