Tutorials » SqlServer tutorials »

Sample SQL statements

In this chapter, you will see some sample SQL statements to perform the CRUD operations.

Assume that you have a database table called 'EMPLOYEE' with the following fields:

1. Id
2. Name
3. Address
4. Salary

The below examples demonstrate the sql statements to perform the CRUD operations.


INSERT INTO Employee (Id, Name, Address, Salary) VALUES (1, 'John', '8900 Research Park Dr', 1200)

The above statement will insert a new record into the employee table. The name of the employee used in the above example is 'John'.


UPDATE Employee SET Name = 'Mr. John', Address = '', Salary = 1400 WHERE id = 1


DELETE FROM Employee WHERE id = 1

The above statement deletes the record of employee whoes Id is 1.


There is no WHERE condition in the above statement and it will delete all records from employee table.


SELECT Id, Name, Address, Salary FROM Employee where ID = 1

The above sql statement finds the record of the employee with the ID = 1.

SELECT Id, Name, Address, Salary FROM Employee

In the above statement, there is no WHERE condition. So, it will return all records from the employee table.

Next Chapter: How to use Management Studio ?
Previous Chapter: Examples of SQL Statements
More Chapters: Sql Server Tutorials
More Tutorials: Tutorial Index

Top Contributors
TodayLast 7 Daysmore...

Awards & Gifts

Online Members

Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India