Insert Query
-
Friends, I stored my 200 values in an array and that 200 values represent one record. It is easy to insert 'n' record, that i did N no. of times with MAX of 20 values but this is first time im supposed to insert this large no. of values. So donno how to do... HELP!!!
-
Friends, I stored my 200 values in an array and that 200 values represent one record. It is easy to insert 'n' record, that i did N no. of times with MAX of 20 values but this is first time im supposed to insert this large no. of values. So donno how to do... HELP!!!
I'd look at your database design and see if a table with 200 columns is really necessary. If it is, you can create an SP with 200 parameters or generate a massive insert statement (both of which are not good solutions!)
-
Friends, I stored my 200 values in an array and that 200 values represent one record. It is easy to insert 'n' record, that i did N no. of times with MAX of 20 values but this is first time im supposed to insert this large no. of values. So donno how to do... HELP!!!
-
Friends, I stored my 200 values in an array and that 200 values represent one record. It is easy to insert 'n' record, that i did N no. of times with MAX of 20 values but this is first time im supposed to insert this large no. of values. So donno how to do... HELP!!!
I prefer a method that will handle generating the query and parameters automatically, that isn't hard-coded to any particular table.