07存储过程和函数.ppt

* You need to ensure that after this demo, the students are able to create and execute user-defined functions. * * * You can summarize the session by running through the summary given in SG. In addition, you can also ask students summarize what they have learnt in this session. * You can summarize the session by running through the summary given in SG. In addition, you can also ask students summarize what they have learnt in this session. * You can summarize the session by running through the summary given in SG. In addition, you can also ask students summarize what they have learnt in this session. * In this slide, you need to explain the CASE construct to the students. You can use the examples given in the Student Guide to clarify the concept to the students. Further, you can execute the following statements to explain the concept: Example: (CASE) SELECT EmployeeID, Marital Status = CASE MaritalStatus WHEN M THEN Married WHEN S THEN Single ELSE Not specified END FROM HumanResources.Employee GO * In this slide, you need to explain the concept of WHILE construct to the students. You can use the examples given in the Student Guide to clarify the concept to the students. Further, you can execute the following statements to explain the concept: Example: (WHILE) WHILE (SELECT AVG(Rate)+1 from HumanResources.EmployeePayHistory) 20 BEGIN UPDATE HumanResources.EmployeePayHistory SET Rate = Rate + 1 FROM HumanResources.EmployeePayHistory IF (Select MAX(Rate)+1 from HumanResources.EmployeePayHistory) 127 BREAK ELSE CONTINUE END * In this slide, you need to explain your students about errors. You can use the examples given in the Student Guide to clarify the concept to the students. * In this slide, you will explain the concept of TRY-CATCH block. Tell your students that this type of handling is known as structured error handling. You can use the examples given in the Student Guide to clarify the concept to the students. Further, you can execute the fo