Join Simon Allardice for an in-depth discussion in this video Writing DELETE statements, part of SQL Server 2008 Essential Training.
A while ago I mentioned that there is an acronym that you'll occasionally…come across with SQL databases which was that of CRUD for create, read, update and delete.…Create obviously being the INSERT INTO statement, read being our SELECT, update…being UPDATE, and we might as well finish it off with some DELETE.…DELETE has an associated word. Like we have UPDATE, SET and INSERT INTO and…SELECT FROM, we have DELETE FROM and in fact DELETE is probably as close to…SELECT as you're going to find.…
In fact this is about the simplest statement there is.…We say we're going to DELETE FROM a particular table.…In this case I'm going to DELETE FROM SalesLT.ProductCategory and I want to be…very careful here because if I hit F5 right now, I would go and delete every row in this table.…The same way that if I said SELECT * FROM we bring back everything, this would…delete everything, and certainly one of the dangers with using SQL Server…management studio or having just admin level access to a database.…
Yes, if you do the wrong thing, you can blow away a lot of stuff very easily.…
- Using T-SQL (Transact-SQL)
- Managing databases with SQL Server Management Studio
- Understanding database normalization
- Using SELECT statements
- Building indexes
- Monitoring database size and integrity
- Backing up and restoring databases
- Creating functions and stored procedures
- Managing database permissions
- Creating and formatting reports
- Adding charts to reports
- Creating and executing a simple SSIS package
Skill Level Beginner
1. Getting Started
2. Installing SQL Server 2008 R2
3. Tools and System Databases
SQL Server system databases2m 22s
4. Creating Databases
5. Importing Existing Data
6. Retrieving Data with SQL
7. Inserting and Updating Data
8. SQL Functions
9. Stored Procedures and Transactions
10. Core Administration Tasks
11. Backing Up and Restoring
12. Security Features
13. Reporting Services
14. Integration Services
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.