----USE DATABASE IN WHICH WE WANT TO INSERT DATA----
USE Hightechnology
GO
----INSERT DATA INTO TABLE----
INSERT INTO STUDENT_INFORMATION(ID,NAME,CLASS,PERMADDRESS) VALUES(2,'JAI','X','DELHI')

SQL Server Insert Into Management Studio:

1. Open SQL Server Management Studio, and connect to SQL Server.

2. Expand Database name > Right click on table, in which you want to insert data and click on Edit Rows.

3. It will open table in editable mode, now we can insert data into columns. Once insertion complete. Close the query window.

Insert Data from one table to another table:

----USE DATABASE IN WHICH WE WANT TO INSERT DATA INTO TABLE----
USE Hightechnology
GO
----INSERT DATA FROM ONE TABLE TO ANOTHER TABLE----
INSERT INTO STUDENT[(ID,NAME,CLASS,PERMADDRESS ,TEMPADDRESS )]
----SELECT DATA FROM OLD STUDENT TABLE----
SELECT ID,NAME,CLASS,PERMADDRESS ,TEMPADDRESS FROM STUDENT_OLD
[WHERE condition];