All Questions
1 question
5
votes
1
answer
20k
views
Fastest way to insert 30 thousand rows in SQL Server
I have to insert 30000 ids in a temporary table ##MyTempTable that has only one column (ID int) and I would like to know which way I could do it fastest.
I have tried 30000 normal inserts
insert ...
- 151