Click here to Skip to main content
12,251,121 members (42,352 online)
   

Database

 
AnswerRe: SQL Select Where query Pin
Nidhisha Biju15-Oct-12 1:05
memberNidhisha Biju15-Oct-12 1:05 
GeneralRe: SQL Select Where query Pin
Eddy Vluggen15-Oct-12 1:26
memberEddy Vluggen15-Oct-12 1:26 
AnswerRe: SQL Select Where query Pin
Aadhar Joshi16-Oct-12 20:47
memberAadhar Joshi16-Oct-12 20:47 
AnswerRe: SQL Select Where query Pin
HiteshDR23-Oct-12 1:06
memberHiteshDR23-Oct-12 1:06 
QuestionMS SQL didn't allow to store apostrophe( ' ) in name Pin
Azher.Cybertech15-Oct-12 0:04
memberAzher.Cybertech15-Oct-12 0:04 
AnswerRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
Eddy Vluggen15-Oct-12 0:55
memberEddy Vluggen15-Oct-12 0:55 
AnswerRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
HiteshDR23-Oct-12 1:08
memberHiteshDR23-Oct-12 1:08 
GeneralRe: MS SQL didn't allow to store apostrophe( ' ) in name Pin
Azher.Cybertech27-Oct-12 23:34
memberAzher.Cybertech27-Oct-12 23:34 
QuestionError Running SP [SOLVED] Pin
jojoba201113-Oct-12 21:53
memberjojoba201113-Oct-12 21:53 
AnswerRe: Error Running SP Pin
Eddy Vluggen14-Oct-12 3:06
memberEddy Vluggen14-Oct-12 3:06 
AnswerRe: Error Running SP Pin
Richard Deeming15-Oct-12 3:38
memberRichard Deeming15-Oct-12 3:38 
QuestionRe: Error Running SP Pin
jojoba201115-Oct-12 4:52
memberjojoba201115-Oct-12 4:52 
NewsRe: Error Running SP [Solved] Pin
jojoba20115-Nov-12 22:37
memberjojoba20115-Nov-12 22:37 
QuestionBug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Allan Watkins12-Oct-12 14:25
memberAllan Watkins12-Oct-12 14: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 11:05
memberjschell13-Oct-12 11:05 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Allan Watkins13-Oct-12 13:02
memberAllan Watkins13-Oct-12 13:02 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
jschell14-Oct-12 6:51
memberjschell14-Oct-12 6:51 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Mycroft Holmes14-Oct-12 15:06
memberMycroft Holmes14-Oct-12 15:06 
GeneralRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Allan Watkins14-Oct-12 19:36
memberAllan Watkins14-Oct-12 19:36 
GeneralThe "bug" is actually in the Fill() method Pin
Allan Watkins16-Oct-12 16:09
memberAllan Watkins16-Oct-12 16:09 
AnswerRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Aadhar Joshi17-Oct-12 1:31
memberAadhar Joshi17-Oct-12 1:31 
QuestionConfigure SQL Server 2005 Remote Access Pin
Kevin Marois11-Oct-12 11:35
memberKevin Marois11-Oct-12 11:35 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Marcus Kramer11-Oct-12 12:06
memberMarcus Kramer11-Oct-12 12:06 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Eddy Vluggen11-Oct-12 12:37
memberEddy Vluggen11-Oct-12 12:37 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Bernhard Hiller12-Oct-12 3:24
memberBernhard Hiller12-Oct-12 3:24 
QuestionGlobal Database Design for example to store Addresses Pin
LiQuick10-Oct-12 21:38
memberLiQuick10-Oct-12 21:38 
AnswerRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson10-Oct-12 22:59
memberJörgen Andersson10-Oct-12 22:59 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen10-Oct-12 23:48
memberEddy Vluggen10-Oct-12 23:48 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 0:16
memberJörgen Andersson11-Oct-12 0:16 
GeneralRe: Global Database Design for example to store Addresses Pin
J4amieC11-Oct-12 0:36
memberJ4amieC11-Oct-12 0:36 
AnswerRe: Global Database Design for example to store Addresses Pin
ihoecken10-Oct-12 23:04
memberihoecken10-Oct-12 23:04 
AnswerRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 0:44
memberEddy Vluggen11-Oct-12 0:44 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 1:36
memberJörgen Andersson11-Oct-12 1:36 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 1:51
memberEddy Vluggen11-Oct-12 1:51 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 1:59
memberJörgen Andersson11-Oct-12 1:59 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 4:42
memberEddy Vluggen11-Oct-12 4:42 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 8:24
memberJörgen Andersson11-Oct-12 8:24 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 10:09
memberEddy Vluggen11-Oct-12 10:09 
AnswerRe: Global Database Design for example to store Addresses Pin
jschell11-Oct-12 9:20
memberjschell11-Oct-12 9:20 
AnswerTHX: Global Database Design for example to store Addresses Pin
LiQuick12-Oct-12 4:21
memberLiQuick12-Oct-12 4:21 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 5:37
memberEddy Vluggen12-Oct-12 5:37 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 8:15
memberJörgen Andersson12-Oct-12 8:15 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 10:54
memberEddy Vluggen12-Oct-12 10:54 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 11:34
memberJörgen Andersson12-Oct-12 11:34 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 13:38
memberEddy Vluggen12-Oct-12 13:38 
QuestionGet Filename and import fixed width file Pin
ReallyDumbDudee10-Oct-12 10:15
memberReallyDumbDudee10-Oct-12 10:15 
AnswerRe: Get Filename and import fixed width file Pin
Eddy Vluggen11-Oct-12 12:51
memberEddy Vluggen11-Oct-12 12:51 
QuestionRe: Get Filename and import fixed width file Pin
ReallyDumbDudee11-Oct-12 13:56
memberReallyDumbDudee11-Oct-12 13:56 
AnswerRe: Get Filename and import fixed width file Pin
Eddy Vluggen12-Oct-12 1:04
memberEddy Vluggen12-Oct-12 1:04 
Answer. Pin
SQL Ed10-Oct-12 8:21
memberSQL Ed10-Oct-12 8:21 

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.160426.1 | Last Updated 3 May 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid