Explain INSERT INTO statement in SQL Server.

The INSERT INTO statement is used to insert new rows in a database table.

Ex :

Insert Into Employees values ( ‘Edward’, ‘14991’, ’16 Indira Nagar’, ‘Chennai’ )

This Query will insert data into “Employee Name”, “Employee ID”, “Address”, “City” columns of “Employees” table

The data can be inserted in specified columns like,

Insert Into Employees ( EmployeeName, City ) values ( ‘Andrew’, ‘Chennai’ )

This Query will insert data into “Employee Name” and “City” column of “Employees” table.