SQL SERVER

Insert Into Command in SQL SERVER

In SQL Server by Baqir AliLeave a Comment

Insert Command in SQL SERVER

Insert command is used to insert data into SQL Server table. You can use the ‘insert command‘ to insert data directly into a table using a T-SQL query or you can use the insert command in CLR or send this command via some other applications.

Insert Command Syntax

Insert into <Table Name>
(columns)
(values)

Example 1: Insert into Command in T-SQL

INSERT INTO Employee_Department
VALUES(10022,'A Smith','Daily Wages',1004,'IT')

In the above code, we have not mentioned the column names. Here we have mentioned values for all columns therefore the column names are not important. Whenever you wanted to enter values for specific columns then you will have to mention the column names also.

Inserting multiple rows into the table

INSERT INTO Employee_Department
VALUES(10022,'A Smith','Daily Wages',1004,'IT')
GO
INSERT INTO Employee_Department
VALUES(10030,'L Jones','Permanet',023,'Pensions')
GO
INSERT INTO Employee_Department
VALUES(21010,'P Lewis','Part Time',004,'IT')
GO
INSERT INTO Employee_Department
VALUES(10010,'B Jones','Trainee',004,'IT')
GO
INSERT INTO Employee_Department
VALUES(10001,'A Smith','Non-Permanent',004,'IT' )
GO
INSERT INTO Employee_Department
VALUES(31002,'T Gilbert','Hourly Wages',028,'Database' )
GO
INSERT INTO Employee_Department
VALUES(13210,'W Richards','Waily Wages',008,'Salary')
GO
INSERT INTO Employee_Department
VALUES(31003,'T Gilbert','Permanet',028,'Database' )
GO
INSERT INTO Employee_Department
VALUES(21023,'P Lewis','Permanent',004,'IT' )
GO
INSERT INTO Employee_Department
VALUES(10034,'B James','Traninee',009,'HR' )
GO

Output:

Insert into T-SQL

Example 2: Insert Command into Specific Columns

INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(10022,004,'A Smith','Daily Wages')
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(10030,023,'L Jones','Permanet')
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(21010,004,'P Lewis','Part Time')
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(10010,004,'B Jones','Trainee')
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(10001,004,'A Smith','Non-Permanent')
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(31002,028,'T Gilbert','Hourly Wages' )
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(13210,008,'W Richards','Waily Wages' )
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(31003,028,'T Gilbert','Permanet'  )
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(21023,004,'P Lewis','Permanent'  )
GO
INSERT INTO Employee(Employee_No,Department_No,Employee_Name,Employee_Type)
VALUES(10034,009,'B James','Traninee'  )
GO

In the above example, we have neglected the column ManagerID

Output:

Insert Command SQL SERVER

Support us by sharing this post

About the Author

Baqir Ali

Facebook Twitter

Hi, I am Baqir Ali ---- Blogger, Programmer, and a Teacher. I am currently working as a Programmer for Softnat Technologies. I have tons of ideas and data to share with you all via blogging.

Leave a Comment