Summary
Today you learned what views are and how to use them. Views are one of the most useful features that you will use in programming T-SQL applications. They enable you to control everything from the number of columns to the amount of data returned to the user.
In addition to working with views, you also learned how to work with temporary tables. In fact, you could use any one of three types of temporary table, depending on the type of work you want to use it for. You also learned how to create temporary tables by using the SELECT ... INTO statement, which creates copies of the existing tables.
Finally, you were briefly exposed to stored procedures in order to create a permanent temporary table when the server starts. Tomorrow you will take ...
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
