SQL SERVER

[Guest_imported]

hi friends

i want to know ! i have to insert 1000 records at a time through ODBC


1.I CAN CREATE PROCEDURE IN SQL SERVER CALL THAT PROCEDURE IN FOXPRO

2.I CAN TAKE LOOP 1 TO 1000 IN FOXPRO USING INSERT INTO STATEMENT

WHICH IS BEST WAY.
THANKS & REGARDS
M.A.KHALEEL
mohaammed

 

[schu]

IMO,

1 is better because stored procedures are faster and in general the server machine is faster than the client. However, 2 is more clearer in what your are trying to do, especially for other people following the code (this can be worked around by having good docs and remarks). 1 is better but i guess it depends on the task you are trying to achieve. Maybe a bit more details would help.

 

[wa8okr]

You could also set up a DTS package to connect to your FoxPro table directly and transfer all the dtat in the table at once. You can start the dts package using the DTS run command.