SQLTeam.com | Weblogs | Forums

Fastest way to load 5,000 records using SQL Query


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


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


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