HOUR 14. Stored Procedure Special Topics
You should be aware of some special topics when writing your stored procedures. In some cases understanding these topics can help you to provide a more efficient solution to a problem. In other cases, these topics address functionality available only with the techniques covered during this hour. In this hour you’ll learn about:
Stored Procedures and Temporary Tables
SQL Server creates temporary tables in a special system database called TempDB. SQL Server creates TempDB each time it starts, ...