Fastest way to load 5,000 records using SQL Query

Transact-SQL
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.