All Type Coding

Search Here

How to insert data into table in sql server.?

The "INSERT INTO" statement is used to insert new records or data  in a table.
Syntax of Insert Into Command:
INSERT INTO table_Name
VALUES(
value1,value2,value3,...)

OR
INSERT INTO table_Name (column1,column2,column3,...)VALUES (value1,value2,value3,...)

Insert into Employee
values(1,'AAA','Delhi','8147280584')
Insert into Employee 
values(1,'BBB','Moradabad','9999999999')
Insert into Employee 
values(1,'CCC','Bangalore','8147280584')
Insert into Employee 
values(1,'DDD','Noida','8147280584')
Insert into Employee 
values(1,'EEE','Haridwar','9927153056')
































Now after inserting the data into table how will see or select data from database. we will use a Select Command like below

Select * from Employee 
After executing this command data will display like below image



No comments :

Post a Comment