34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
Softlee81307 2005-03-11
- 打赏
- 举报
set rowcount 20 -------設定刪除的數目
delete from tablename
delete from tablename
xluzhong 2005-03-11
- 打赏
- 举报
如果有自增id
delete from tablename where id in(select top 20 id from tablename)
delete from tablename where id in(select top 20 id from tablename)
xluzhong 2005-03-11
- 打赏
- 举报
set rowcount 20
delete from tablename
set rowcount 0
delete from tablename
set rowcount 0
