Solved

remove data from SQL table - SQL 2008 R2

Posted on 2011-09-25
2
320 Views
Last Modified: 2012-05-12
A user has added approx 5000 incorrect entries into a DB. I would like to remove them.
Lets assume there are 2 columns in this table-
Serial number and Reference number.

Lets assume the incorrect serial numbers are all between 10000 and 15000.
How do I remove them?

I am not an SQL expert, so would appreciate if you can paste the query I need to run.  
0
Comment
Question by:Mayogroup
2 Comments
 
LVL 15

Accepted Solution

by:
Eyal earned 250 total points
ID: 36597273
delete from tablename where serial >= 10000 and serial <=15000
0
 
LVL 9

Assisted Solution

by:mimran18
mimran18 earned 250 total points
ID: 36597330
Delete from tablename where [serial Number] between 10000 and 15000
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Insert where not exists 24 46
Challenging SQL Update 5 49
SQL Server 2012 r2 - calculations/operation on many Temp Tables 6 26
Sql query with where clause 2 34
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question