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.