如何在SQL中翻转随机位
|
为了进行测试，我想通过将列中的位设置为随机值来更新表。
update [Planned]
set [IsPlannable] = 1 * rand(cast(cast(newid() as binary(8)) as int))
WHERE [ComputerID] > 100
没有找到相关结果
已邀请:
3 个回复
先对冈蒲
仍将产生分数，并且假定given2ѭ得1，as3ѭ则更新均设置为1。 你可以;醒荒捆府绣
with test as ( select 0 as myId, cast(0 as bit) col1, cast(0 as bit) col2, cast(0 as bit) col3 union all select myId + 1, case when myId & 1 = 1 then cast(1 as bit) else cast(0 as bit) end, case when myId & 2 = 2 then cast(1 as bit) else cast(0 as bit) end, case when myId & 4 = 4 then cast(1 as bit) else cast(0 as bit) end from test where myId<100 ) select distinct col1, col2, col3 from test谦响局豢报