/****** SSMS 的 SelectTopNRows 命令的脚本 ******/
SELECT TOP (1000) [stud_id]
,[stud_name]
,[c1]
FROM [test01].[dbo].[student]
1.
declare @te int
declare @i int
declare c cursor
for (select stud_id from [student])
open c
fetch next from c into @i
while @@FETCH_STATUS=0
begin
set @te=(select c1 from [student] where stud_id=@i)
if @te is null
update [student] set c1= stud_id
else
update [student] set c1=5
FETCH NEXT FROM c INTO @i
end
close c
deallocate c
2. update student set c1=( case when c1 is null then stud_id else c1+'123' end)
sql update 根据条件更新
最新推荐文章于 2024-07-30 03:41:19 发布