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 -E
then hit enter
If 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 GO
GO 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