Click here to Skip to main content
12,826,142 members (28,866 online)
   

Database

 
AnswerRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
HiteshDR23-Oct-12 2:08
memberHiteshDR23-Oct-12 2:08 
GeneralRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
Azher.Cybertech28-Oct-12 0:34
memberAzher.Cybertech28-Oct-12 0:34 
QuestionError Running SP [SOLVED] Pin
jojoba201113-Oct-12 22:53
memberjojoba201113-Oct-12 22:53 
AnswerRe: Error Running SP Pin
Eddy Vluggen14-Oct-12 4:06
memberEddy Vluggen14-Oct-12 4:06 
AnswerRe: Error Running SP Pin
Richard Deeming15-Oct-12 4:38
memberRichard Deeming15-Oct-12 4:38 
QuestionRe: Error Running SP Pin
jojoba201115-Oct-12 5:52
memberjojoba201115-Oct-12 5:52 
NewsRe: Error Running SP [Solved] Pin
jojoba20115-Nov-12 23:37
memberjojoba20115-Nov-12 23:37 
QuestionBug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Allan Watkins12-Oct-12 15:25
memberAllan Watkins12-Oct-12 15:25 
I believe I've found a very unexpected bug in SQLBulkCopy that took me a while to track down. My test program reads in records from a CSV file with exactly 1 column which is defined as a "numeric(19,5)" for statistical uploads.

Condition 1:
If the input file has 25 rows with the only value being the digit zero, followed by a number with a decimal (like '1.23456'), the data is imported perfectly.
Condition 2:
If the input file has 26 rows with the only value being the digit zero (or any non-decimal number), followed by a number with a decimal (like '1.23456'), the data is imported and the last (and any subsequent) rows have the field imported with truncated decimal digits (like '1.00000').
Condition 3:
If the input file has 26 rows and the first row is '0.0', all of the rows are imported perfectly.

I've checked the table/field definition for Condition 2 and it's the same as 1 and 3 so there's no manipulation of the field type (as far as I can tell).

Is this a bug or am I missing something?
AnswerRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
jschell13-Oct-12 12:05
memberjschell13-Oct-12 12:05 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Allan Watkins13-Oct-12 14:02
memberAllan Watkins13-Oct-12 14:02 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
jschell14-Oct-12 7:51
memberjschell14-Oct-12 7:51 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Mycroft Holmes14-Oct-12 16:06
memberMycroft Holmes14-Oct-12 16:06 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Allan Watkins14-Oct-12 20:36
memberAllan Watkins14-Oct-12 20:36 
GeneralThe "bug" is actually in the Fill() method Pin
Allan Watkins16-Oct-12 17:09
memberAllan Watkins16-Oct-12 17:09 
AnswerRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Aadhar Joshi17-Oct-12 2:31
memberAadhar Joshi17-Oct-12 2:31 
QuestionConfigure SQL Server 2005 Remote Access Pin
Kevin Marois11-Oct-12 12:35
memberKevin Marois11-Oct-12 12:35 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Marcus Kramer11-Oct-12 13:06
memberMarcus Kramer11-Oct-12 13:06 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Eddy Vluggen11-Oct-12 13:37
memberEddy Vluggen11-Oct-12 13:37 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Bernhard Hiller12-Oct-12 4:24
memberBernhard Hiller12-Oct-12 4:24 
QuestionGlobal Database Design for example to store Addresses Pin
LiQuick10-Oct-12 22:38
memberLiQuick10-Oct-12 22:38 
AnswerRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson10-Oct-12 23:59
memberJörgen Andersson10-Oct-12 23:59 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 0:48
memberEddy Vluggen11-Oct-12 0:48 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 1:16
memberJörgen Andersson11-Oct-12 1:16 
GeneralRe: Global Database Design for example to store Addresses Pin
J4amieC11-Oct-12 1:36
memberJ4amieC11-Oct-12 1:36 
AnswerRe: Global Database Design for example to store Addresses Pin
ihoecken11-Oct-12 0:04
memberihoecken11-Oct-12 0:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170326.1 | Last Updated 28 Mar 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid