how to particially delete record in sql server - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to particially delete record in sql server

how to particially delete record in sql server# Database - 数据库

a*h2000-06-10 07:06

1 楼

how to particially delete record in sql server
if there are 1000 pieces of record in a table, how can i
accomplish the following tasks:
1. delete record 1 to record 500.
2. delete record 500 to record 1000.
3. delete record 300 to record 500.

a*h2000-06-10 07:06

2 楼

a*s2000-06-10 07:06

3 楼

But I doubt that record is always in order.

【在 a***h 的大作中提到】

: how to particially delete record in sql server
: if there are 1000 pieces of record in a table, how can i
: accomplish the following tasks:
: 1. delete record 1 to record 500.
: 2. delete record 500 to record 1000.
: 3. delete record 300 to record 500.

a*h2000-06-10 07:06

4 楼

there is a field for ID, but such ID is not an
autonumber(it is not an auto-increase number).

【在 a****s 的大作中提到】

: But I doubt that record is always in order.