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 →

Help Others, Please Share

Learn Latest Tutorials

Arduino tutorial

Arduino

Digital Electronics tutorial

Digital E.

Google Adwords tutorial

Adwords

MySQL

Python

Smartsheet

affiliate marketing

Affiliate M.

Software Testing Tutorial

Testing

Proc*C

social media marketing

SMM

GDB

Fuzzy Logic

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