Solved

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

Posted on 2004-09-09
16
224 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
 
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

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…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now