Sign in | Join | Help

Piotr Rodak

if datepart(dw, getdate()) in (6, 7)
use pubs;

This Blog

  • Home
  • Contact

Syndication

  • RSS
  • Atom
  • Comments RSS

Search

  • Go

Tags

    • bcp
    • BLOB
    • bug
    • bulk insert
    • c#
    • collation
    • concurrency
    • configuration
    • data access
    • data import
    • database maintenance
    • deadlocks
    • distributed transaction
    • download
    • error
    • errors
    • ETL
    • events
    • format files
    • linked server
    • locking hits
    • MARS
    • Numbers table
    • OLE DB
    • OPENQUERY
    • performance
    • photography
    • practices
    • Profiler
    • programming
    • Reporting Services
    • revelations
    • scientific notation
    • script
    • security
    • source code
    • SSIS
    • SSRS
    • Sybase
    • Tally table
    • textsize
    • tips and tricks
    • trace flags
    • trigger
    • troubleshooting
    • truncate
    • t-sql
    • util

Navigation

  • Home
  • Blogs
  • Forums
  • Photos
  • Downloads

Archives

  • March 2010 (1)
  • February 2010 (2)
  • January 2010 (4)
  • December 2009 (2)
  • November 2009 (1)
  • October 2009 (2)
  • September 2009 (1)
  • July 2009 (1)
  • June 2009 (1)
  • May 2009 (1)
  • April 2009 (1)
  • March 2009 (1)
  • November 2008 (1)
  • April 2008 (1)
  • December 2007 (1)
  • November 2007 (3)
  • October 2007 (2)

Browse by Tags

All Tags » format files (RSS)
  • bcp
  • bug
  • bulk insert
  • data import
  • scientific notation
  • tips and tricks
  • t-sql
17 May 2009 00:49

BCP and numeric data field with scientific notation

There 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...
Posted by Piotr Rodak | with no comments
Filed under: tips and tricks, t-sql, format files, bulk insert, scientific notation, data import, bcp, bug
 
Powered by Community Server (Commercial Edition), by Telligent Systems