SQL Server Examples

SQL DML

String Functions

Stored Procedures

SQL Views

SQL Table Basics

SQL Server DELETE Examples

Delete a row of data.

BEGIN TRANSACTION
GO

DELETE FROM [dbo].[ClassRegistration]
WHERE      classes_num  = 2  
       AND seat_num     = 12  
GO

COMMIT TRANSACTION
GO

Delete multiple rows of data. Be careful!

BEGIN TRANSACTION
GO

DELETE FROM [dbo].[ClassRegistration]
WHERE   seat_num     >= 12  
GO

COMMIT TRANSACTION
GO