Click here to Skip to main content
11,478,896 members (75,983 online)
   

Database

 
GeneralRe: Staging Area Pin
S Douglas29-Nov-12 8:52
memberS Douglas29-Nov-12 8:52 
Questionfirst linq for entity frame work? Pin
Member 875182715-Nov-12 2:02
memberMember 875182715-Nov-12 2:02 
AnswerRe: first linq for entity frame work? Pin
digimanus15-Nov-12 4:17
memberdigimanus15-Nov-12 4:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pin
vanikanc14-Nov-12 8:40
membervanikanc14-Nov-12 8:40 
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION Pin
Phanindra26114-Nov-12 9:40
memberPhanindra26114-Nov-12 9:40 
QuestionFault Exception in WCF Services Pin
Phanindra26114-Nov-12 7:15
memberPhanindra26114-Nov-12 7:15 
AnswerRe: Fault Exception in WCF Services Pin
Eddy Vluggen14-Nov-12 7:36
memberEddy Vluggen14-Nov-12 7:36 
GeneralRe: Fault Exception in WCF Services Pin
Phanindra26114-Nov-12 9:05
memberPhanindra26114-Nov-12 9:05 
QuestionRelation multiple table using in C# Pin
YBG13-Nov-12 3:53
memberYBG13-Nov-12 3:53 
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 9:23
memberPhanindra26114-Nov-12 9:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 9:19
memberSQL Ed12-Nov-12 9:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 12:33
memberEddy Vluggen12-Nov-12 12:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 20:03
memberPhanindra26111-Nov-12 20:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 11:08
memberjschell12-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 Pin
Mycroft Holmes12-Nov-12 13:51
memberMycroft Holmes12-Nov-12 13:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 19:40
memberPhanindra26113-Nov-12 19:40 
QuestionHow to create reports effectively [modified] Pin
Frygreen9-Nov-12 1:52
memberFrygreen9-Nov-12 1:52 
AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 3:32
memberDavid Mujica9-Nov-12 3:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 5:08
memberMycroft Holmes9-Nov-12 5:08 
AnswerRe: How to create reports effectively Pin
Frygreen9-Nov-12 5:10
memberFrygreen9-Nov-12 5:10 
Suggestionsql server 2008 security Pin
Member 36227527-Nov-12 9:00
memberMember 36227527-Nov-12 9:00 
GeneralRe: sql server 2008 security Pin
Mycroft Holmes7-Nov-12 12:27
memberMycroft Holmes7-Nov-12 12:27 
GeneralRe: sql server 2008 security Pin
jschell8-Nov-12 9:56
memberjschell8-Nov-12 9:56 
QuestionHelp me my Sql expired Pin
mehdi_nassiri00986-Nov-12 11:03
membermehdi_nassiri00986-Nov-12 11:03 
AnswerRe: Help me my Sql expired Pin
Jörgen Andersson6-Nov-12 11:22
memberJörgen Andersson6-Nov-12 11:22 
AnswerRe: Help me my Sql expired Pin
Joy Sinha22-Nov-12 21:09
memberJoy Sinha22-Nov-12 21:09 
QuestionADO.NET Pin
M.T.H.Danish6-Nov-12 7:25
memberM.T.H.Danish6-Nov-12 7:25 
AnswerRe: ADO.NET Pin
Richard MacCutchan6-Nov-12 8:28
mvpRichard MacCutchan6-Nov-12 8:28 
AnswerRe: ADO.NET Pin
Eddy Vluggen6-Nov-12 10:18
memberEddy Vluggen6-Nov-12 10:18 
GeneralADO.NET Pin
M.T.H.Danish6-Nov-12 7:11
memberM.T.H.Danish6-Nov-12 7:11 
AnswerRe: ADO.NET Pin
ihoecken6-Nov-12 7:27
memberihoecken6-Nov-12 7:27 
QuestionSQL SERVER 2008 Pin
M.T.H.Danish6-Nov-12 3:49
memberM.T.H.Danish6-Nov-12 3:49 
AnswerRe: SQL SERVER 2008 Pin
David Mujica6-Nov-12 4:27
memberDavid Mujica6-Nov-12 4:27 
AnswerRe: SQL SERVER 2008 Pin
J4amieC6-Nov-12 4:31
memberJ4amieC6-Nov-12 4:31 
AnswerRe: SQL SERVER 2008 Pin
djj556-Nov-12 5:43
memberdjj556-Nov-12 5:43 
AnswerRe: SQL SERVER 2008 Pin
Michael Potter6-Nov-12 5:47
memberMichael Potter6-Nov-12 5:47 
GeneralAwesome solution Pin
David Mujica6-Nov-12 9:39
memberDavid Mujica6-Nov-12 9:39 
GeneralRe: Awesome solution Pin
Srini Sydney14-Nov-12 12:24
memberSrini Sydney14-Nov-12 12:24 
GeneralRe: SQL SERVER 2008 Pin
Mycroft Holmes6-Nov-12 13:11
memberMycroft Holmes6-Nov-12 13:11 
GeneralRe: SQL SERVER 2008 Pin
Michael Potter7-Nov-12 6:23
memberMichael Potter7-Nov-12 6:23 
SuggestionRe: SQL SERVER 2008 Pin
Eddy Vluggen7-Nov-12 6:47
memberEddy Vluggen7-Nov-12 6:47 
GeneralRe: SQL SERVER 2008 Pin
Michael Potter8-Nov-12 9:54
memberMichael Potter8-Nov-12 9:54 
GeneralRe: SQL SERVER 2008 Pin
Eddy Vluggen8-Nov-12 9:57
memberEddy Vluggen8-Nov-12 9:57 
GeneralRe: SQL SERVER 2008 Pin
Mycroft Holmes7-Nov-12 12:25
memberMycroft Holmes7-Nov-12 12:25 
QuestionException in Win 7 while trying to connect the application to Access DB. Pin
rskuchimanchi6-Nov-12 2:52
memberrskuchimanchi6-Nov-12 2:52 
AnswerRe: Exception in Win 7 while trying to connect the application to Access DB. Pin
Eddy Vluggen6-Nov-12 3:11
memberEddy Vluggen6-Nov-12 3:11 
QuestionAnsiNulls and QuatedIdentifiers default values Pin
eli150219795-Nov-12 22:23
membereli150219795-Nov-12 22:23 
AnswerRe: AnsiNulls and QuatedIdentifiers default values [RESOLVED] Pin
eli150219795-Nov-12 23:19
membereli150219795-Nov-12 23:19 
Questionexporting Table to Excel file by TSQL Problem Pin
mehdi.sabet4-Nov-12 21:28
groupmehdi.sabet4-Nov-12 21:28 
AnswerRe: exporting Table to Excel file by TSQL Problem Pin
Eddy Vluggen5-Nov-12 0:48
memberEddy Vluggen5-Nov-12 0:48 

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
Web04 | 2.8.150520.1 | Last Updated 22 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid