<div>
You can use SELECT INTO statement to input data to new table in SQL Server.
</div>


You can use SELECT INTO statement to input data to new table in SQL Server.

<div>
<div class="content wysiwyg-content">
I have a DataTable object, filled with data from an existing query (used a DataAdaptor and SQL statement).<br />
<br />
I want to put the data in this DataTable object into a new table in an SQL Server database.<br />
How do I make the table and populate it as fast as possible from a C# application?
</div>
</div>


I have a DataTable object, filled with data from an existing query (used a DataAdaptor and SQL statement).

I want to put the data in this DataTable object into a new table in an SQL Server database.
How do I make the table and populate it as fast as possible from a C# application?

Save a DataTable to SQL Server database and make the database table at the same time

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.