Conditional delete from query in sql enterprise manager
Posted on 2006-11-27
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?