27,579
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([性别] nvarchar(21))
Insert #T
select N'男' union all
select null union all
select N'女' union all
select null union all
select N'男' union all
select N'男' union all
select null
Go
--测试数据结束
;WITH cte AS(
Select *,ROW_NUMBER()OVER(ORDER BY GETDATE()) AS num from #T WHERE 性别 IS NULL
)
UPDATE cte SET 性别= CASE WHEN num%3=0 THEN '男' ELSE '女' END
SELECT * FROM #T