Delete in SQL Server

In SQL Server by Baqir AliLeave a Comment

How to delete a row in SQL Server

Delete Command is used to delete existing data from a table.

The Data that is entered incorrectly should be deleted or sometimes we want to delete all data from a table we use Delete Command

Delete from Person.Person

The above code will delete all data from the Person table.

Delete from Person.Person
Where BusinessEntityID=1

This will delete a specific record, a record whose BusinessEntityID is 1.

Support us by sharing this post

About the Author

Baqir Ali

Facebook Twitter

Hi, I am Baqir Ali ---- Blogger, Programmer, and a Teacher. I am currently working as a Programmer for Softnat Technologies. I have tons of ideas and data to share with you all via blogging.

Leave a Comment