Am using Sql server 2008,
i have three columns in a table.. i need to insert 50 lak records.. do i want to run loop like below or any other way..
for i as integer = 1 to 500000
'insert query
next
Printable View
Am using Sql server 2008,
i have three columns in a table.. i need to insert 50 lak records.. do i want to run loop like below or any other way..
for i as integer = 1 to 500000
'insert query
next
Have a look at the SqlBulkCopy class.