Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

SQL 2000 query analyzer

I am trying to delete all rows in all table's in one data base that have a certain value say (MX)$ how can I do this using SQL query analyzer 2000
0
Jeff1976
Asked:
Jeff1976
  • 3
  • 2
3 Solutions
 
arnoldCommented:
You have to use sql query browser not analyzer.
You have to make sure that you are deleting from tables in the correct order dealing with constraints if any.
0
 
Jeff1976Author Commented:
Ok I can not find SQL query browser for SQL 2000 installed is it a seperate install or download and how do I figure out what order to use or the constraints. I am really new to this.
0
 
arnoldCommented:
Constraints are part of the database setup that deal with preventing deletion of records that other tables rely on.
Do you have enterprise manager installed?
Is this Sql 2000 or MSDE?

The enterprise manager and the sql browser have to be installed using the CD.

Have not used it in a while, http://toadforsqlserver.com/index.jspa
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Jeff1976Author Commented:
this is SQL 2000 standard
0
 
arnoldCommented:
If you have the disk rerun the install and make sure to install the enterprise manager tools.
0
 
Anthony PerkinsCommented:
You should be able to do that with SQL Query Analyzer.  

Is this what you mean:
DELETE YourTableName WHERE YourColumnName = '(MX)$'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now