How to split the Lengthy Insert Command Line Text Line ?

Question

5.00/5 (1 vote)

See more:

, +

Hi, I have table around 90 Columns. Now my problem is when I wish to use the Insert Command
it's not executing... The reason is that the command is very lengthy... So how to split the line ?

My Command

C++

SqlCommand^ DetailedInsert = gcnew SqlCommand("Insert into Table1 (col1,col2,col3,...col90) values (val1,val2,val3,...val90)", SqlCon);

DetailedInsert->ExecuteNonQuery();

So that DatiledInsert Command Text is very lengthy, How to split that line?

Thanks

Posted 20-Nov-13 22:28pm

Paramu1973

Updated 20-Nov-13 22:30pm

v3

Add a Solution

Comments

KarstenK 21-Nov-13 4:44am

Consider to redesign the database. Use some redunancy to clean up the fat tables. If you have different tables, the statement will get lighter.

This bad design will result in low performance of all operation.

agent_kruger 21-Nov-13 4:49am

why do you need 90 columns?

CPallini 21-Nov-13 4:51am

What is the error you get? Such a huge number of columns is probably poor design, however, I suppose, the database (and code) should handle it correctly.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Freak30 · Answer 1 · 2013-11-20T22:50:00

Solution 1

If your table has a unique key (or possibly several columns that are unique if taken together) you can first insert some columns (including the unique one(s)) and then update the row with several update commands like this

SQL

update Table1 set col11 = val11, col12 = val12 ... col20 = val20
where col1 = val1;

assuming column 1 is your unique key.

Posted 20-Nov-13 22:50pm

Freak30

Comments

Paramu1973 21-Nov-13 6:03am

Nope...Its my requirement for diffrent purpose, so all comments are not gives a solution.....to my requirement

How to split the Lengthy Insert Command Line Text Line ?

1 solution

Solution 1

Add your solution here

Preview 0

How to split the Lengthy Insert Command Line Text Line ?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us