|
View previous topic :: View next topic
|
| Author |
Message |
jitu852
New User
Joined: 30 Apr 2007
Posts: 27
Location: Hyderabad
|
|
|
|
hi
when i use to delete a table with huge records it gives -904
since it has huge records; even though i empty it using where condition but it not efficient ....
so i want to know about any verb for delete table with huge record( i want to empty it only )
even i heard about TRANCATE
can any body haelp me on this (i meams its use and syntax) |
|
| Back to top |
|
 |
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hi jitu852,
Why dont u ask the above question in new topic??
Your SQL code says: unavailable resource. Someone is locking the data you need, you may choose to terminate the program |
|
| Back to top |
|
|
|
|
