SQL Server Transact Basic to Expert - Delete Query

This blog shows how to use the delete statement in order to delete the contents of the table. Delete statements are used in different ways based on the requirement to delete a single record to delete the bulk of records etc.

Syntax:

Delete FROM table
Where condition

Example:

Delete from emptable
Where empid = 1

This deletes only a single row which is of empid = 1