a***h
发帖数: 29 | 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***h
发帖数: 29 | 2 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****s
发帖数: 47 | 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***h
发帖数: 29 | 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.
|
n******e
发帖数: 50 | 5 SQL中没有记录号的概念. 你只能用key来指定所要操作的特定记录.
autoincrement的key也不是记录号, 例如你把key=100的记录删了,
key=101的记录不会自己改成100.
【在 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.
|
