SQL Server--存储过程if else分情况更新

 1 USE [HumidifyMachine]
 2 GO
 3 
 4 /****** Object:  StoredProcedure [dbo].[sp_UpdateTaskEndWithException]    Script Date: 2020/3/9 16:02:45 ******/
 5 SET ANSI_NULLS ON
 6 GO
 7 
 8 SET QUOTED_IDENTIFIER ON
 9 GO
10 
11 CREATE procedure [dbo].[sp_UpdateTaskEndWithException]
12 as
13 if exists(select * from T_Task where Status>=0 and Status<40)
14     begin
15     Update T_Task 
16         set Status=50 where Status>=0 and Status<40
17     end
18 else if exists(select * from T_Task where Status>=60 and Status<100)
19     begin
20     Update T_Task
21         set Status=110 where Status>=60 and Status<100
22     end
23 GO