Error Fix: invalid precision for decimal data type in SQL Server 2005/2008

Some time you may be greeted with the error “invalid precision for decimal data type” while exporting your SQL Server table to Microsoft Excel. The main root cause of this error is, Excel doesn’t not support Decimal precision greater than 28. If you try to export a SQL Table which has column with Decimal(29,0), you probably found this error. In this case, there is only one solution is to decrease your precision limit in SQL Server table to <=28 and you will be ok.

Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com

Advertisements

4 Responses to “Error Fix: invalid precision for decimal data type in SQL Server 2005/2008”

  1. Ritesh Shah Says:

    Thanks for blessing.

  2. Ritesh Shah Says:

    Thanks for blessing.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: