求SQL语句。。。。。。。。。。。

[Qxlyh]

一个表：table3
三个字段：ID，Title,ClassID

我想用ORDER BY NEWID() 随机选取N条,将这N条的ClassID更新为1，请问SQL语句应怎么写，十分感谢。

[paoluo]

ID是不是關鍵字？？

[Qxlyh]

ID是自动编号，主键。

[九斤半]

create table test
(id int identity(1,1) not null,
title varchar(8000),
classid int)

insert test(title,classid)
select 'afdsaf',2
union all select 'asfdsafasf',9
union all select 'sdfafsaf',89
union all select 'sdfafsaf',3

select * from test

update test set classid=classid +1 where id in(
select top 2 id from test order by newid())

select * from test

drop table test

[九斤半]

将这N条的ClassID更新为1
刚才看才加1了，
update test set classid=1
where id in (select top 2 id from test order by newid())

[paoluo]

如果N是固定的


Update table3
Set classid=1
Where ID In(Select Top 3 ID From table3 Order By NewID())

[Qxlyh]

谢谢楼上两位

[paoluo]

如果不固定，可以用動態語句


Create Table table3
(ID Int Identity(1,1),
Title Varchar(10),
ClassID Int)
Insert table3 Select 'aa',0
Union All Select 'bb',2
Union All Select 'cc',3
Union All Select 'dd',4
Union All Select 'ee',5
GO
Declare @N Int
Set @N=3
EXEC('Update table3 Set classid=1 Where ID In(Select Top '+@N+' ID From table3 Order By NewID())')

Select * From table3
GO
Drop Table table3
--Result
/*
ID Title ClassID
1 aa 0
2 bb 2
3 cc 1
4 dd 1
5 ee 1
*/

[Qxlyh]

5555....
爱你