1

Topic: DELETE TOP as means of struggle with

Kind time of days;
Question on :
It is necessary to jam an unlimited amount of lines from the table without creation of the big noises to users.
It is necessary to rub on a nonunique field i.e. in advance it will not be known how many lines to rub.
For this purpose I want to make a cycle and to rub on slices, we tell 4500 that was not .
Now the question as is better to write this:
DELETE TOP....
Or
DELETE.... WHERE Field IN (SELECT TOP....)?
Thanks.

2

Re: DELETE TOP as means of struggle with

Daba wrote:

that was not .

What is it?

Daba wrote:

DELETE TOP

+

3

Re: DELETE TOP as means of struggle with

[quote = _ human] it is passed...
What is it?
it is passed...

Truth do not know? 8-o
https://msdn.microsoft.com/ru-ru/library/ms189835 (v=sql.100).aspx