Solved

Conditional delete from query in sql enterprise manager

Posted on 2006-11-27
5
287 Views
Last Modified: 2013-12-03
Trying to delete rows for the condition below in sql enterprise manager does nothing but tell me the query was run.

delete from downloads
where id < 5000
and filesize < 200000

I want to delete all rows where the id is less than 5000 and the filesize is less than 200000. There are no other conditions. No triggers I can see. Nothing unusual. If I remove the conitions and simply run "delete from downloads" the rows are deleted, except I do get a timeout.

So, what might I be doing wrong and how can I correct it?

 - Georgia

0
Comment
Question by:RollinNow
5 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 100 total points
Comment Utility
Did you try it from Query analyser ? the problem with the EM is that it will create a duplicate of that table and try to delete the data from there,  so this is not advisable.
0
 

Author Comment

by:RollinNow
Comment Utility
Yes I did, that is, just now, first time. I was told there were 0 rows affected. I'm sure the id and filesize values are correct.

Also, is there a timeout statement I can use in the query?
0
 
LVL 9

Accepted Solution

by:
dduser earned 300 total points
Comment Utility
Select * from downloads
where id < 5000
and filesize < 200000

How many rows this returns???

Regards,

dduser
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 100 total points
Comment Utility
>I want to delete all rows where the id is less than 5000 and the filesize is less than 200000.
do you mean to delete all the rows that have id 5000    and delete all the rows  that have filesize less than 200000, or do you need both conditions at the same time?
if you need either condition, then use OR:
delete from downloads
where ( id < 5000 or filesize < 200000 )

resp:
delete from downloads
where id < 5000

delete from downloads
where filesize < 200000


0
 

Author Comment

by:RollinNow
Comment Utility
Looks like the rows were all above 200000 filesize. Silly me!

Thanks for holding my hand!

 - Georgia
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now