Information générale
Forum:
Microsoft SQL Server
>>I know that, I can get same result by transfer the cursor record by record in scan loop.
>>But in this tecnique at one time tranfer periyod is very long for 500.000 records. I hope to shorten execution time by transfering cursor.
>>
>>Ali Altun
> Never tryed this, so the ansver is pure theoretical, but you can write a Stored Procedure in SQL Server and pass the table as parameter
> then you can use INSERT ... FROM OPENROWSET() or BULK INSERT from a VFP table (not cursors I suppose)
Thanks Borissov
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement