I have a datatable DT
with 25 columns. I want to insert that data from DT
into a SQL Server table SQDT
with the same columns. I’m using an INSERT
query for now.
Is there a better way to approach this problem instead of using INSERT
on each record? Can I bulk insert into the database using a stored procedure or some other efficient way? It takes a lot of time to insert as DT
has 130000 tuples.