Solved

How do I delete all the records in an SQL Table called ItemAnalysisDetail

Posted on 2004-09-09
16
228 Views
Last Modified: 2010-04-23
How do I delete all the records in an SQL Table called ItemAnalysisDetail

Thanks
Kenny
0
Comment
Question by:kwh3856
  • 9
  • 6
16 Comments
 
LVL 4

Expert Comment

by:Javert93
ID: 12020871
Through SQL or .NET?
0
 
LVL 5

Expert Comment

by:LindzK
ID: 12020939
DELETE * FROM ItemAnalysisDetail
0
 

Author Comment

by:kwh3856
ID: 12020998
SQL.......Query Analyzer????  Can I do it from there???

Thanks
Kenny
0
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.

 
LVL 5

Expert Comment

by:LindzK
ID: 12021021
yes, just run that command :-

 DELETE * FROM ItemAnalysisDetail

make sure you have the right database selected in the drop down box
0
 

Author Comment

by:kwh3856
ID: 12021038
when I run the DELETE * FROM ItemAnalysisDetail
I get Incorrect syntax near '*'.
0
 
LVL 5

Expert Comment

by:LindzK
ID: 12021047
for good examples of simple sql comands visit this site - it's pretty useful for starting off

http://www.w3schools.com/sql/default.asp
0
 
LVL 5

Expert Comment

by:LindzK
ID: 12021052
try it without the *
0
 

Author Comment

by:kwh3856
ID: 12021090
neither one of those worked.  I read the tutorial and see what you are talking about.  These examples did not work for me.  I am using SQL 2000 Dev Edition and trying to use SQL Query Analyzer to delete the rows.  Is this the correct way????

Thanks
Kenny
0
 
LVL 5

Expert Comment

by:LindzK
ID: 12021179
hmm, that should work and sql query analyzer is fine for doing what you need - one sec, i'll try and look into it :)
0
 

Author Comment

by:kwh3856
ID: 12021290
Here is what I typed into SQL Query Analyzer while the table was selected in the left view pane
DELETE * FROM ItemAnalysisDetail


Here is the exact error message

Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '*'.


Thanks
Kenny

0
 
LVL 5

Accepted Solution

by:
LindzK earned 500 total points
ID: 12021340
as well as the left hand pane - there is usually a drop down box above the main text area - do you have one of them ? is you database selected ? and not northiwind or somethng similar
0
 

Author Comment

by:kwh3856
ID: 12021386
The master was selected in the drop down pane but I changed it to the database.  I still got the same error message with the *.  I will try it now without the *.

Thanks
Kenny
0
 
LVL 5

Expert Comment

by:LindzK
ID: 12021398
just as a test try doing

delete from ItemAnalysisDetail where columnname = 'sometext'  for me, see if that runs through.

where columnname = a columnname in your database
 and sometext = some text you know exists in that column

keep the text in '  '   or if it's a numeric value , dont
0
 

Author Comment

by:kwh3856
ID: 12021404
You Win!!!!!!!!!!!!!!!!!


Thank you very much :)


Thanks
Kenny
0
 
LVL 5

Expert Comment

by:LindzK
ID: 12021421
it worked with the db in the drop down ? :)
0
 
LVL 5

Expert Comment

by:LindzK
ID: 12021426
thanks for teh points - glad we got to the bottom of it !
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question