MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server FAST TRACK - Temp Tables and Table Variables

Course Summary

Get up to speed quickly with TEMP TABLES and TABLE VARIABLES. Learn how they work and when to use which table type.


  • +

    Course Syllabus

    • Temporary Tables
      • * * SECTION DESCRIPTION * *
      • Temp Table Example 1 - Persistence - TSQL and the Temp Database
      • Temp Table Example 2 - Persistence and STORED PROCEDURES
      • Temp Table Example 3 - Persistence - TSQL vs STORED PROCEDURES
      • Temp Table Example 4 - Command Line TSQL
      • Temp Table Example 5 - Command Line TSQL with IF EXISTS and DROP TABLE
      • Temp Table Example 6 - Command Line TSQL with IDENTITY
      • Temp Table Example 7 - STORED PROCEDURE
      • Temp Table Example 8 - STORED PROCEDURE - IF EXISTS and DROP TABLE?
      • Temp Table Example 9 - Command Line TSQL vs STORED PROCEDURE
      • Temp Table Example 10 – TEMP TABLES vs REAL TABLES
      • SECTION 1 - REVIEW QUIZ
    • Table Variables
      • * * SECTION DESCRIPTION * *
      • Table Variables Example 1 - No Persistence
      • Table Variables Example 2 - Command Line TSQL
      • Table Variables Example 3 - Command Line SQL - No Need to DROP TABLE
      • Table Variables Example 4 - Command Line TSQL with IDENTITY
      • Table Variables Example 5 - STORED PROCEDURE
      • Table Variables Example 6 - STORED PROCEDURE - Multiple Tables
      • Table Variables Example 7 - USER DEFINED FUNCTION
      • Table Variables Example 8 - Table Variables vs Temp Tables - Command Line TSQL
      • SECTION 2 - REVIEW QUIZ


  • Course Fee:
    USD 59

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    1 - 4 hours / week

    This course is listed under Data & Information Management Community

    Attended this course?

     

    Back to Top

    Awards & Accolades for MyTechLogy
    Winner of
    REDHERRING
    Top 100 Asia
    Finalist at SiTF Awards 2014 under the category Best Social & Community Product
    Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
    Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
    Hidden Image Url

    Back to Top