Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andreacaffy
Starting Member
6 Posts |
 Posted - 2011-11-16 : 09:32:14
|
| Hi,I have a problem with a particular table of a particular database.If for example I try to delete some rows with an update statement I don't be able to do it.If I try to drop table or update table I don't be able to do these operations.When from MSServer Management Studio I write my instructions and execute query, I see "Executing query". For hours I continue to see "executing query" until I stop the instruction.What can I do?I try to import data into another table of the same database. Here all works, even if I lose triggers, keys and constraints and identity specification of any column. And then I can't be able to drop the old table.Please help me. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-16 : 10:26:29
|
| I try to delete some rows with an update statementsorry how would you delete rows using update? you should be using delete statement for that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
andreacaffy
Starting Member
6 Posts |
Posted - 2011-11-16 : 10:37:39
|
| Excuse me. I write wrong. I try to delete some rows with a delete statement, that is "delete from table where field=1" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-11-21 : 03:29:11
|
| How many rows are there in the table?MadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-21 : 03:35:55
|
quote:
Originally posted by andreacaffy
Excuse me. I write wrong. I try to delete some rows with a delete statement, that is "delete from table where field=1"
did you check the execution plan for this query? is there some table scan involved? what are costly steps?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Drop table Problem