http://sqlblogcasts.com/blogs/piotr_rodak/archive/tags/bug/tips+and+tricks/scientific+notation/default.aspxTags: bug, tips and tricks, scientific notationenCommunityServer 2007.1 (Build: 20917.1142)http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/05/17/bcp-and-numeric-data-field.aspxSat, 16 May 2009 23:49:00 GMTfa8c4e8e-46a3-4193-8264-2c1a9cb3475d:11680Piotr Rodak0http://sqlblogcasts.com/blogs/piotr_rodak/rsscomments.aspx?PostID=11680http://sqlblogcasts.com/blogs/piotr_rodak/commentapi.aspx?PostID=11680http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/05/17/bcp-and-numeric-data-field.aspx#commentsThere is a known issue in SQL Server 2005 with importing data using bcp.exe or BULK INSERT methods from character files that contain numeric values written using scientific notation, like 2.044E10. It was not a problem in versions prior to 2005 because...(<a href="http://sqlblogcasts.com/blogs/piotr_rodak/archive/2009/05/17/bcp-and-numeric-data-field.aspx">read more</a>)<img src="http://sqlblogcasts.com/aggbug.aspx?PostID=11680" width="1" height="1">tips and trickst-sqlformat filesbulk insertscientific notationdata importbcpbug