ALTER PROCEDURE [dbo] [save record] 
@ counter a smallint output, @ counter 2 smallint output 
AS 
The BEGIN 
IF the EXISTS (conditions) 
The BEGIN 
Perform work A record number included in the counter is updated () 
Perform work B (update record number included in the counter a) 
Perform work C (update record number included in the counter 2) 
END 
IF the EXISTS (2) 
The BEGIN 
Perform work A record number included in the counter is updated () 
Perform work B (update record number included in the counter a) 
Perform work C (update record number included in the counter 2) 
END 
END 

I want to calculate and return the two set of updates, could you tell me how to deal with?

CodePudding user response:

How to calculate "calculate"? Every time call a stored procedure, conditions 1 and 2 should be handled?

CodePudding user response:

If meet the condition is executed after judgment, could only perform one, could only perform two, May 1 and 2 are executed,

CodePudding user response:

reference 1st floor RINK_1 response:

how to calculate "calculate"? Every time call a stored procedure, conditions 1 and 2 should be handled?

condition in two steps and a two steps included in the number of unit 1 a,