求一SQL,功能文中SQL,不过我写那个肯定不行,有语法错误

[nealwike]

UPDATE TOP 1 iesoonet.qyml SET saleserve='管理员'
where saleserve='蔡仁杰'
order by newid()

[liangCK]

不能在update里用order by

[贾桂权]

UPDATE TOP (1) iesoonet.qyml SET saleserve='管理员'
where saleserve='蔡仁杰'
order by newid()

[liangCK]

;WITH Liang AS
(
    SELECT rnk=ROW_NUMBER() OVER(ORDER BY NEWID()),*
    FROM iesoonet.qyml
    WHERE saleserve='蔡仁杰' 
)
UPDATE Liang SET
    saleserve='管理员'
WHERE rnk=1;

[贾桂权]

UPDATE TOP (1) iesoonet.qyml SET saleserve='管理员'
where saleserve='蔡仁杰'

[htl258_Tony]

;with t as
(
 select top(1) * from iesoonet.qyml where saleserve='蔡仁杰' order by newid()
)
update t set saleserve='管理员'  

[nealwike]

[Quote=引用 1 楼 liangCK 的回复:]
不能在update里用order by
[/Quote]

哦,受教

[水族杰纶]

set rowcount  1
go
UPDATE  iesoonet.qyml SET saleserve='管理员' 
where saleserve='蔡仁杰' 
go
set rowcount  0

[sdhdy]

？
UPDATE iesoonet SET saleserve='管理员'
where saleserve='蔡仁杰'

[rucypli]

UPDATE iesoonet.qyml SET saleserve='管理员' 
where saleserve='蔡仁杰' 
and id =(select top 1 id from qyml order by newid())

[conan304]

[Quote=引用楼主 nealwike 的帖子:]
UPDATE TOP 1 iesoonet.qyml SET saleserve='管理员'
where saleserve='蔡仁杰'
order by newid()
[/Quote]

with tempdb as
(
  select top(1) * from iesoonet.qyml where saleserve='蔡仁杰' 
)

update tempdb
SET saleserve='管理员'