Click here to Skip to main content
       

Database

 
QuestionSQL BulkCopy using IDataReader - how can you cast the fields? PinmemberAllan Watkins26-Dec-12 19:12 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? PinmemberMycroft Holmes26-Dec-12 20:32 
GeneralRe: SQL BulkCopy using IDataReader - how can you cast the fields? PinmemberAllanW1111127-Dec-12 6:02 
AnswerRe: SQL BulkCopy using IDataReader - how can you cast the fields? PinmemberPIEBALDconsult27-Dec-12 8:48 
QuestionSubquery returns more than 1 row PinmemberJassim Rahma24-Dec-12 1:02 
AnswerRe: Subquery returns more than 1 row PinmemberEddy Vluggen24-Dec-12 1:29 
AnswerRe: Subquery returns more than 1 row PinmemberMaulikDusara24-Dec-12 21:44 
GeneralRe: Subquery returns more than 1 row PinmemberEddy Vluggen25-Dec-12 2:41 
MaulikDusara wrote:
True, this is the main reason for such errors. Many resolution are available for this errors.

1) Use Top 1 keyword i.e.

That's assuming that there's more of those records allowed in the table, and being an "Id", this COULD lead to an inconsistent database - exaggerating the problem.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

GeneralRe: Subquery returns more than 1 row PinmemberMycroft Holmes26-Dec-12 11:17 
GeneralRe: Subquery returns more than 1 row PinmemberMaulikDusara26-Dec-12 18:45 
GeneralRe: Subquery returns more than 1 row PinmemberEddy Vluggen27-Dec-12 4:24 
QuestionOn the Naming of Columns for Lookup tables. PinmemberBrady Kelly17-Dec-12 22:44 
AnswerRe: On the Naming of Columns for Lookup tables. PinmemberMycroft Holmes17-Dec-12 23:19 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly17-Dec-12 23:26 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberMycroft Holmes18-Dec-12 1:11 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 1:15 
AnswerRe: On the Naming of Columns for Lookup tables. PinmemberPIEBALDconsult18-Dec-12 4:05 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 4:12 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberPIEBALDconsult18-Dec-12 4:46 
GeneralRe: On the Naming of Columns for Lookup tables. PinmemberBrady Kelly18-Dec-12 5:34 
QuestionOn Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 3:02 
JokeRe: On Strategies to Spell Check the Structure of a Database. PinmemberChris Meech14-Dec-12 4:31 
AnswerRe: On Strategies to Spell Check the Structure of a Database. PinmemberSimon_Whale14-Dec-12 4:52 
AnswerRe: On Strategies to Spell Check the Structure of a Database. PinmemberMycroft Holmes14-Dec-12 13:12 
GeneralRe: On Strategies to Spell Check the Structure of a Database. PinmemberBrady Kelly14-Dec-12 16:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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.140814.1 | Last Updated 15 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid