Sql Server Delete Data

SQL Server DELETE Data

In SQL Server database, DELETE statement is used to delete records from the table.

SQL server delete data 1

Syntax:

  SELECT TOP 1000 [ID]        ,[NAME]        ,[AGE]        ,[SALARY]    FROM [tutoraspire].[dbo].[STUDENT]  

Use the SQL Server management Studio:

Follow the management studio screenshots given below:

SQL server delete data 2

Use the following command:

SQL server delete data 3

Here one row is deleted where ID=3. You can verify it:

Output:

SQL server delete data 4