Insert Into Statement in SQL Server(TSQL)

dbtut January 2, 2019 MSSQL, TSQL

We use the Insert Into Statement to add data to a table. We can use the Insert Into Statement in a number of different ways.

You can see these uses in the sample script below.

First, we are creating a table:

Use [TestDB]
GO
CREATE TABLE [dbo].[MyTable]
(Name VARCHAR(25))
GO

Use [TestDB]

CREATE TABLE [dbo].[MyTable]

(Name VARCHAR(25))

Now, We will insert a value into this table in fourth methods.

First Method For Insert Operation:

USE [TestDB]
GO
INSERT INTO [dbo].[MyTable] ([Name]) VALUES ('Nurullah ÇAKIR')
GO

USE [TestDB]

INSERT INTO [dbo].[MyTable] ([Name]) VALUES ('Nurullah ÇAKIR')

Second Method For Insert Operation:

USE [TestDB]
GO
INSERT INTO [dbo].[MyTable] VALUES ('Nurullah ÇAKIR')
GO

USE [TestDB]

INSERT INTO [dbo].[MyTable] VALUES ('Nurullah ÇAKIR')

Third Method For Insert Operation:

INSERT INTO [dbo].[MyTable] VALUES ('Nurullah ÇAKIR'),('Faruk ERDEM')

1	INSERT INTO [dbo].[MyTable] VALUES ('Nurullah ÇAKIR'),('Faruk ERDEM')

Fourth Method For Insert Operation:

In this method, we are inserting values from MyTable to MyTable2

USE [TestDB]
GO
INSERT INTO [dbo].[MyTable2] Select [Name] from MyTable
GO
Select Name From MyTable
Select Name From MyTable2

USE [TestDB]

INSERT INTO [dbo].[MyTable2] Select [Name] from MyTable

Select Name From MyTable

Select Name From MyTable2

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux