Just create an Update query as a text string and execute it. There is no need to store it as a stored procedure, although that would be faster. You can move data from one table to another using 1 (one) query. If you don't know how this works, check the documentation of SQLServer or fire up Access and try it there. BTW the problem might also be related to your ODBC driver. Did you try a JDBC driver like the one from NetDirect (http://www.j-netdirect.com)? Jave has very poor performance with ODBC and certainly the one for MSSQLServer sucks!! Bert
At 18:59 17/12/2001 +0800, you wrote: >I have a problem with query. >I wanna move lots data from, could be hundred records from a table in a >database A to a table in database B when a user click a button. >But i got error Out Of Memory. This is because i select all records from >database A at once and then move it to database B. Anyone has good way for >this case without using stored procedure ? only depends to Select command >in java class. >I am using MSSql as the database here > >== >thx, >a Java Addicted =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
