delete some records in a table without using top and where clause.

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

for ex: I have 5000 records in a table I want to delete any 1000 records in a table
without using Top and where Clause
how I can help me.

Posted 8-Oct-15 21:43pm

Gajana Paralkar

Updated 8-Oct-15 22:48pm

Tomas Takac

v2

Add a Solution

Comments

[no name] 9-Oct-15 3:57am

On which basis/condition, do you want to delete 1000 records. Whether top 1000 or below 1000 or any other condition are there. And is there any primary key present in that table.

Gajana Paralkar 9-Oct-15 5:13am

delete any 1000 records records in a table no condition but don't use Top and where Clause. no primary key

want to delete 1000 records how?

2 solutions

Solution 2

Without giving condition you can't delete the required records, there should be some condition for deleting records, without that means it's delete all the records.

As "OriginalGriff" Suggested recheck your requirement and come back with the proper requirement.

Posted 8-Oct-15 23:29pm

Naveen.Sanagasetti

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2015-10-08T22:45:00

The problem is that unless you have a WHERE clause or similar SQL will delete all records - so to restrict your input to just "any 1000 records" you would need some kind of filtering.

I'm pretty sure that you are trying to do something that would be better handled elsewhere, because deleting random records is not a function SQL is normally used for.
Id'd sit back and think about exactly what you are trying to do and why you think SQL is a good vehicle for this before continuing.