Click here to Skip to main content
       

Database

 
AnswerRe: Fault Exception in WCF Services PinmemberEddy Vluggen14-Nov-12 7:36 
GeneralRe: Fault Exception in WCF Services PinmemberPhanindra26114-Nov-12 9:05 
QuestionRelation multiple table using in C# PinmemberYBG13-Nov-12 3:53 
AnswerRe: Relation multiple table using in C# PinmemberPhanindra26114-Nov-12 9:23 
QuestionTrying to get a MySQL subquery to return multiple records PinmemberSQL Ed12-Nov-12 9:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records PinmemberEddy Vluggen12-Nov-12 12:33 
QuestionSending data to database PinmemberPhanindra26111-Nov-12 20:03 
AnswerRe: Sending data to database Pinmemberjschell12-Nov-12 11:08 
Presumably it throws an exception and posting that exception as part of your post is helpful.
 
Presuming that the exception is telling you the statement is too big...
 
If your SQL statement is too long then SQL/C# will have a problem with it. The solution is to reduce the size. (Might note that that could indicate a database design issue as well.)
 
Using the database import tools (sqlldr?) might help with the problem but might not. If not or you don't want to use it then solutions.
1. Do two calls.
2. Pass in a blob and parse it to create dynamic sql.
 
If it was me I would presume that there is a design issue.
AnswerRe: Sending data to database PinmemberMycroft Holmes12-Nov-12 13:51 
GeneralRe: Sending data to database PinmemberPhanindra26113-Nov-12 19:40 
QuestionHow to create reports effectively [modified] PinmemberFrygreen9-Nov-12 1:52 
AnswerRe: How to create reports effectively PinmemberDavid Mujica9-Nov-12 3:32 
AnswerRe: How to create reports effectively PinmemberMycroft Holmes9-Nov-12 5:08 
AnswerRe: How to create reports effectively PinmemberFrygreen9-Nov-12 5:10 
Suggestionsql server 2008 security PinmemberMember 36227527-Nov-12 9:00 
GeneralRe: sql server 2008 security PinmemberMycroft Holmes7-Nov-12 12:27 
GeneralRe: sql server 2008 security Pinmemberjschell8-Nov-12 9:56 
QuestionHelp me my Sql expired Pinmembermehdi_nassiri00986-Nov-12 11:03 
AnswerRe: Help me my Sql expired PinmemberJörgen Andersson6-Nov-12 11:22 
AnswerRe: Help me my Sql expired PinmemberJoy Sinha22-Nov-12 21:09 
QuestionADO.NET PinmemberM.T.H.Danish6-Nov-12 7:25 
AnswerRe: ADO.NET PinmvpRichard MacCutchan6-Nov-12 8:28 
AnswerRe: ADO.NET PinmemberEddy Vluggen6-Nov-12 10:18 
GeneralADO.NET PinmemberM.T.H.Danish6-Nov-12 7:11 
AnswerRe: ADO.NET Pinmemberihoecken6-Nov-12 7:27 

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.141223.1 | Last Updated 26 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid