The INSERT statement in Sql server is used to insert new records in a table.
We can insert new records in two forms:-
First:-
Insert into table_name values (value1,value2,value3)
Second:-
Insert into table_name(coloum1,coloum2) values(value1,value2)
Insert into Example:-
| ID | Name | Class | Roll No |
| 1 | Jai | B.A | 12 |
| 2 | Mohan | M.A | 23 |
| 4 | Om | B.A | 2 |
Query:-
insert into example values(5,'Ram','D.ed','26')
Result:-
| ID | Name | Class | Roll No |
| 1 | Jai | B.A | 12 |
| 2 | Mohan | M.A | 23 |
| 4 | Om | B.A | 2 |
| 5 | Ram | D.Ed | 26 |