Specified column precision 52 is greater than the maximum precision of 38

Posted by Gaur1982 under Sql Server on 6/28/2012 | Points: 10 | Views : 2843 | Status : [Member] | Replies : 2
I am creating a new SP(Stored Procedure) in SQL Server 2008 and it will gives me an error i.e.

Specified column precision 52 is greater than the maximum precision of 38

I can't understand that why this error occurs?

Please let me explain why this error occurs and how can i solve this error.

Gaurav Agrawal
http://www.planetofcoders.com/



Responses

Posted by: Gaur1982 on: 6/28/2012 [Member] Starter | Points: 25

Up
0
Down
I got my mistake and really this is a silly mistake which generated by me by mistake. I declared a parameter which datatype is decimal and by mistake i tool decimal's length 52. so it given an error because decimal maximum length id 38.

Gaurav Agrawal
http://www.planetofcoders.com/

Gaur1982, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ajay.Kalol on: 6/28/2012 [Member] Starter | Points: 25

Up
0
Down
can you put your SP code sample.





Ajay
ajaypatelfromsanthal.blogspot.in

Gaur1982, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response