next → ← prev

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 [javatpoint].[dbo].[STUDENT]

Use the SQL Server management Studio:

Follow the management studio screenshots given below:

SQL server delete data 2

Use the following command:

DELETE FROM [javatpoint].[dbo].[STUDENT]
      WHERE ID =3;

SQL server delete data 3

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

Output:

SQL server delete data 4

Next TopicSQL Server Delete TOP

← prev next →

For Videos Join Our Youtube Channel: Join Now

Help Others, Please Share

Learn Latest Tutorials

PostgreSQL

Apache Solr Tutorial

Solr

MongoDB

Gimp

Verilog Tutorial

Verilog

Teradata Tutorial

Teradata

PhoneGap Tutorial

PhoneGap

Gmail

Vue.js Tutorial

Vue.js

PLC

Adobe Illustrator Tutorial

Illustrator

Preparation

Aptitude

Logical Reasoning

Reasoning

Verbal A.

Interview

Company Interview Questions

Company

Trending Technologies

Artificial Intelligence Tutorial

AI

AWS

Selenium tutorial

Selenium

Cloud

Hadoop

ReactJS Tutorial

ReactJS

Data Science Tutorial

D. Science

Angular 7 Tutorial

Angular 7

Blockchain Tutorial

Blockchain

Git

Machine Learning Tutorial

ML

DevOps Tutorial

DevOps

B.Tech / MCA

DBMS

Data Structures tutorial

DS

DAA

Operating System tutorial

OS

Computer Network tutorial

C. Network

Compiler Design tutorial

Compiler D.

Computer Organization and Architecture

COA

Discrete Mathematics Tutorial

D. Math.

Ethical Hacking Tutorial

E. Hacking

Computer Graphics Tutorial

C. Graphics

Software Engineering Tutorial

Software E.

Web Tech.

Cyber Security tutorial

Cyber Sec.

Automata Tutorial

Automata

C

C++

Java

.Net Framework tutorial

.Net

Python

List of Programs

Programs

Control Systems tutorial

Control S.

Data Mining Tutorial

Data Mining

Javatpoint Services

JavaTpoint offers too many high quality services. Mail us on hr@javatpoint.com, to get more information about given services.

Website Designing
Website Development
Java Development
PHP Development
WordPress
Graphic Designing
Logo
Digital Marketing
On Page and Off Page SEO
PPC
Content Development
Corporate Training
Classroom and Online Training
Data Entry

Training For College Campus

JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at hr@javatpoint.com.
Duration: 1 week to 2 week

^{Like/Subscribe us for latest updates or newsletter}

Subscribe to Get Email Alerts

YouTube