In how many ways we can insert records in sql server

Question

Like inserting single or multiple records at a time, one table data is inserting into another table with limited columns.

There is no [SQL statement](https://learn.microsoft.com/en-us/sql/t-sql/statements/statements) named `Edit top 200 rows` - anything that a GUI offers (which I assume you are referring to with "Edit top ..") will eventually be carried out using an `INSERT` statement. — , Apr 11 '18 at 06:19
Whatever it is DML or GUI but need how many approaches we have — Swamy, Apr 11 '18 at 06:24
As I said: [`INSERT`](https://learn.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql) is the approach to insert new rows — , Apr 11 '18 at 06:30
pls see if this helps - https://msbiskills.com/2015/04/09/different-methods-to-insert-multiple-rows-using-single-insert-keyword/ — Pawan Kumar, Apr 11 '18 at 07:29
This is what I am looking for thank you @PawanKumar and need from table to table insertion. — Swamy, Apr 11 '18 at 07:41

score 2 · Accepted Answer · answered Apr 11 '18 at 08:40

There are (at least) four ways:

INSERT. Pretty obvious. It supports both single rows and multiple rows supplied as literal values, as well as inserting the result of a query or stored procedure.
SELECT .. INTO inserts the results of a query into a new table.
BULK INSERT. Bulk inserts data from files. It's a little quirky and not very flexible when it comes to parsing files, but if you can get the data to line up it works well enough. Selecting data for bulk insert purposes can also be done with OPENROWSET(BULK, ...).
INSERT BULK. This is an internal command that's used under the covers by drivers that use the bulk insert protocol in TDS (the protocol used by SQL Server). You do not issue these commands yourself. Unlike BULK INSERT, this is for client-side initiated bulk inserting, for example through the SqlBulkCopy class in .NET, or SQL Server's own bcp tool.

All other interfaces and approaches to inserting data use one of these methods under the covers. Most of these will use plain old INSERT.

score 0 · Answer 2 · answered Apr 11 '18 at 08:27

Hope this will help

2 Answers2