标准简单SP模板（sql server）

CREATE Procedure eSP_ChangeStart   --eSP_ChangeStart 64  
 @ID int,  
 @RetVal Int = 0 Output  
    
As      
Declare      
  @Badge varchar(10),      
  @ID_Max int      
Begin      
      
 Select @Badge = Badge   
 From eChange_Register     
 Where [ID] = @ID      
         
 --该登记记录是否确认      
 IF Not Exists(Select 1 From eChange_Register Where ID = @ID and IsNull(Initialized,0) = 1)      
 Begin      
  Set @RetVal = 911005      
    Return @RetVal      
 End    
    
  Begin Transaction      
  
    Update a      
    Set a.DepID = b.DepID
    From Employee a,eChange_Register b      
    Where a.Badge = b.Badge             
      
IF @Type=2    
Begin      
  Set @RetVal = 911014      
  Commit Transaction      
  Return @RetVal      
End    
    
IF @Type=1    
Begin      
  Set @RetVal = 911091      
  Commit Transaction      
  Return @RetVal      
End