34,575
社区成员
发帖
与我相关
我的任务
分享
比如:
id sid name
1 0 aaa
2 3 bbb
3 1 ccc
4 4 ddd
5 2 eee
我要整体更新,其它所有值不变,
sid的值变为1,2,3,4,5
update a
set sid = (select count(*) from tablea where id <= a.id)
from tablea a
id sid name
102 0 aaa
232 3 bbb
311 1 ccc
400 4 ddd
555 2 eee
update a
set sid = (select count(*) from tablea where id <= a.id)
from tablea a
update tablea
set sid = case when id = 8 then id else sid end,
name = name + 'xxxx'
update tablea
set sid = id
1.什么叫整体更新,全部更新?
update [Table] set sid='1,2,3,4,5'
2.
update [Talle] set sid=8 where id=1
@declare @sid int
set sid = 2
update table set
name = name+'xxx',
sid = 2
where xxx
id sid name
102 0 aaa
232 3 bbb
311 1 ccc
400 4 ddd
555 2 eee