In this step by step SQL Tutorial I will show you how to remove rows from a table . For the purpose of this tutorial I will use SQL Server 2012.
Other Versions of SQL Server:
- SQL Server 2012
- This blog post has been written using SQL Server 2012
- SQL Server 2008 / R2
- The examples we used should work in SQL Server 2008 and R2
- SQL Server 2005
- We suspect that this will work in SQL Server 2005 as well
Who is it for?
- People who would like to learn basics of using SQL DELETE
- Those who are preparing for Microsoft certifications and need to cover this topic.
Delete allows to remove rows from a table and you can write delete query with filters so you delete only the rows you want.
To better understand DELETE let's create a task that is close to real-life. In our story imagine you are a developer
that has been ask to clean your table before loading new data from spreadsheet. In the following example I will show you how you could solve your task.
DELETE using SSMS 2012
For this example I will use AdventureWorksDW2012 database, dbo.DatabaseLog table.
Learn as much as you like
Unlimited learning access pass*
* Secure one off payment, no re-occuring payments, no surprises T-SQL SSIS SSRS 79 Mini Courses 529 Pages 287 Videos 314 Articles
Forum Live Webinars 12 Webinar Recordings DIY Projects Progress TrackingNew member joins every 8 hours
60 days, 100% money back guarantee
NO risks, NO questions asked, NO hard feelings
I can't speak highly enough of the quality MSBI materials industry practitioners with varying level of experience and exposure can benefit from this website. Their structured learning plan and courses, DIY projects, webinars and relevant resources go a very long way.
I've gained a whole new perspective on delivering client BI projects to highest standards by employing best practices recommended on this website.
Best quality MSBI training online suite I have used and least expensive too.
Best and affordable BI Training platform in the web.
KEBI Academy doesn't provide training on BI rather their approach is to make you learn BI by yourself.
Self Learning is always the best approach and I recommend KEBI Academy.
You both are doing a great job by sharing your knowledge and experience,
it helps many people who want to learn MSBI from the starting point and also for an experienced person to get to know more about MSBI.
Thank you and keep sharing your MSBI knowledge and experience.
Great work on the videos. I have been enjoying them.