Deleting Rows by Using DELETE - TechNet - Microsoft

SQL Server 2008 R2 ... All rows in table_or_view that meet the qualifications of the WHERE search condition are deleted. ... The following example shows the Transact-SQL extension used to delete ...

technet.microsoft.com