继续求sql,需求如文中SQL.

[nealwike]

数据库是sql2000
错误的语句(做需求描述):

UPDATE TOP 2 table1 SET column1='value2'
	where saleserve='value1'
	order by newid()

请暂不考虑:
UPDATE table1 SET column1='value2'
where saleserve='value1' WHERE 主键 IN(
SELECT TOP 2 主键 FROM table1 order by newid())
我想知道有没有其他办法.

[-狙击手-]

SET ROWCOUNT 2
go
UPDATE table1 
SET column1='value2'
where saleserve='value1'
order by newid()

[-狙击手-]

SET ROWCOUNT 2;
UPDATE table1 
SET column1='value2'
where saleserve='value1'
order by newid();
SET ROWCOUNT 0;

[水族杰纶]

--TRY
set rowcount 2
go
UPDATE  table1 SET column1='value2'
    where saleserve='value1'
go
set rowcount 0

[Yang_]

declare @i int
set @i = 0
UPDATE table1 SET 
    @i = @i +1
    column1= case when @i>2 then column1 else 'value2' end
where saleserve='value1'
order by newid()

[nealwike]

[Quote=引用 2 楼 happyflystone 的回复:]
SQL codeSET ROWCOUNT 2;
UPDATE table1
SET column1='value2'
where saleserve='value1'
order by newid();
SET ROWCOUNT 0;
[/Quote]
update 里面好像不能用ORDER BY

[ks_reny]

關注.

[ws_hgo]

SET ROWCOUNT 2;

[nealwike]

额...
都不行哦
update 语句不能用order by 哦