Create table, Insert, Update, Delete, Search in table in SQL SERVER

We will study syntax of Create table, Insert, Update, Delete, Search in table in SQL SERVER and example:- 

Syntax of Create table:-

  

   
CREATE TABLE tblName
(
Column1 data_type, Column1 data_type, Column1 data_type, Column1 data_type,......
)


Example:-

CREATE TABLE tblStudentRecord
(
Name varchar(100), Rollno int primary key, Branch varchar(30),Email varchar(100),Address varchar(200)
)

Insert record in table :- 

Syntax :-

  

INSERT INTO tblName values(data1, data2, data3, data4, data5,.......)

                      OR

INSERT INTO tblName (Column1, Column1, Column1, Column1.......) values(data1, data2, data3, data4, data5,.......)

Example :-

  

INSERT INTO tblStudentRecord VALUES('Santosh kumar singh',1001,'Information Technology','sa@gmail.com','A-3033')
INSERT INTO tblStudentRecord VALUES('Er. Reena Tanti',1002,'ECE','err@gmail.com','T-387, Gaya')
INSERT INTO tblStudentRecord VALUES('Chandan kumar',1003,'CSE','chn@gmail.com','Gaya')
INSERT INTO tblStudentRecord VALUES('Nand kishor kumar',1004,'BCA','nk@gmail.com','A-3033,Darbhanga')
INSERT INTO tblStudentRecord VALUES('Abhinav kumar',1005,'MCA','ab@gmail.com','H-837')

Update record in table :- 

Syntax :-

  

UPDATE TABLE_NAME SET COLUMN_NAME1='SOME DATA', COLUMN_NAME1='SOME DATA',COLUMN_NAME1='SOME DATA',......WHERE CONDITION

Now, i want to update record of Chandan kumar. I want to change Branch CSE to ECE. Before update table look like as below:-

  

UPDATE tblStudentRecord SET Branch='ECE' WHERE Rollno=1003

After update table look like as below 

Delete record from table :- 

Syntax :-

  

DELETE FROM TABLE_NAME WHERE CONDITION

Example :- I want to Delete record of Chandan kumar from tblStudentRecord table:- 

  

DELETE FROM tblStudentRecord WHERE Rollno=1003

After delete Chandan kumar record from tblStudentRecord table and table look like this:- 

Search record from table :- 

Syntax :-

  

--FOR GET ALL RECORD
SELECT * FROM TABLE_NAME

--FOR PARTICULAR COLUMNS

SELECT COLUMN1, COLUMN2, COLUMN3, WHERE CONDITION

Example :- 

  

--FOR GET ALL RECORD
SELECT * FROM tblStudentRecord


--FOR PARTICULAR COLUMNS SUCH AS NAME AND BRANCH
SELECT Name,Branch FROM tblStudentRecord WHERE Rollno=1001