Posted by figital on 10/02/38 11:44

You could also pass in an XML file and directly insert its contents
into a table. I've found this method several times faster (in my case,
8x) than calling an stored procedure for each record.

• Next in forum: Re: SQL Server 2005 vs Oracle
• Prev in forum: Re: rights issues with linked server
• Thread view: Re: Maximum number of records per second that can be inserted into SQLServer 2000.

[Reply to this message]