تفاصيل الدورة

This is an in depth course about programming with TEMP TABLES and TABLE VARIABLES in SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject.

Temp tables and table variables can solve a lot of the trickier challenges faced by developers so you need to become expert with them.

This course will get cover all of the following:

TEMP TABLES

  • Temp Tables and the Temp Database (tempdb)
  • Persistence
  • Persistence in STORED PROCEDURES
  • Persistence - TSQL vs STORED PROCEDURES
  • Command Line TSQL examples
  • IDENTITY column usage
  • STORED PROCEDURE usage
  • Command Line TSQL vs STORED PROCEDURE
  • TEMP TABLES vs REAL TABLES
  • TABLE VARIABLES
  • No Persistence
  • Command Line TSQL examples
  • IDENTITY column usage
  • STORED PROCEDURE usage
  • USER DEFINED FUNCTION usage
  • Table Variables vs Temp Tables: How they are similar and how they differ
  • Benefits and drawbacks to each type
  • تحديث بتاريخ 27 December, 2017
    دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على SQL Server ابتداءً من الآن. See all courses

    قيِم هذه الصفحة