Workshop

The Workshop provides quiz questions to help you solidify your understanding of the material covered and exercises to provide you with experience in using what you've learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, "Answers to Quizzes and Exercises," and make sure that you understand the answers before continuing to the next lesson.

Quiz

1:User-defined functions can return scalar values as well as tables and can be used as part of the SELECT statement or in the FROM clause of a query. True or False?
2:What are the three different types of user-defined functions?

Exercise

1:Using the Northwind database, create a function that accepts a ZIP Code and returns a table of customer names and addresses.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset