请教一条sql 命令：替换数据库中某一列的前N行

来源：百度知道 编辑：UC知道 时间：2024/06/11 17:00:37
我的mssql 2005中有个表list，默认当然是按照id列升序排序的
然后我用title列为准升序排序后，想替换isaccept列的前100行的内容0为1
isaccept列的内容目前全为0

请朋友们帮忙提供命令

//先将isaccept全部归零 （必须的，不然上次改成1的还是1）
UPDATE [list] SET [isaccept]=0;

//然后修改前100条
UPDATE [list] SET [isaccept]=1 WHERE [id] IN (SELECT TOP 100 [id] FROM [list] ORDER BY [title]);

update list set isaccept =1 where id in (select top 100 id from list order by title desc)

update list set isaccept = 1 where id in (select top 100 is from list order by title asc)

update list set isaccept = 1 where id <101

update list set isaccpet=1 where id in (select top 100 id from list)