This video will teach you how to run the DELETE statement with working examples, within SQL Server, we also look at the alternatives of removing data from a database.
DELETE FROM ‘table name’
WHERE ‘column’ = ‘value’
Remember always take a backup, for a tutorial on how to back up databases click the link below:
• SQL Tutorial - Backup and Restore
To learn how to INSERT data in to a table click the link below:
• SQL Tutorial - INSERT
To learn how to UPDATE data in a database click the link below:
• SQL Tutorial - UPDATE
You’re Fired:
DELETE FROM MyEmployees
WHERE EmployeeID IN (16, 23)
Rename table:
EXEC sp_rename 'Books_New', 'Books_Old'
To check out other videos on my channel click the link below:
/ @beardeddevdata
On this page of the site you can watch the video online SQL Tutorial - DELETE with a duration of hours minute second in good quality, which was uploaded by the user BeardedDev 19 April 2017, share the link with friends and acquaintances, this video has already been watched 396 times on youtube and it was liked by 12 viewers. Enjoy your viewing!