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 |
|
tempcontrol
Starting Member
2 Posts |
 Posted - 2004-06-11 : 10:52:19
|
| I am trying to delete several entries at once from a MSDE database table. Is there software or a command that will make this possible? I do not have access to SQL server, but do have MSDE manager from Vale software. This is not capable of doing that. Thanks for any information. |
|
|
JasonGoff
Posting Yak Master
158 Posts |
Posted - 2004-06-11 : 11:26:58
|
| Doesn't MSDE come with OSQL, the command-line tool for running queries against a database ?Use that to run a DELETE FROM MyTable WHERE <condition> on your table. |
 |
|
|
tempcontrol
Starting Member
2 Posts |
Posted - 2004-06-11 : 12:13:29
|
| Thanks for the info. I am a SQL newbie to the extreme, but I will search for information on using the utility. Thanks again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-11 : 13:07:04
|
| Go to Start then Run. Type in cmd and hit enter. At the command prompt, type in:osql -SServerName -Ethen hit enterIf you get connected successfully, you'll see >1.You are now connected to the master database or whatever your default database is set to. So now:>1 USE DBName>2 GO>1 DELETE FROM MyTable WHERE Column1 = 0>2 GOGO says to execute previous batch. So just change the queries as appropriate. Type in exit when you are done then exit again to close the cmd window.Tara |
|
|
|
|
|
|
Deleting Multiple Entries in a Table