SQLTeam.com | Weblogs | Forums

Fastest way to load 5,000 records using SQL Query


#1

Dear SQL Developers,

Good day!

May I humbly seek for your help to load a 5,000 records in a fastest way (let's say on one table) using SQL query.

Thank you


#2

What do you mean by "load"? From a file? From another table? Into a new table, existing table?


#3

If it's from a consistently formatted file and not some crazy format such as EDI, then BULK INSERT is the fastest method.