New Transact SQL Video Tutorial: Part 4 - WHILE Loops and Implementing Looping Structure in SQL

Part 4 - WHILE Loops and Implementing Looping Structure in SQL - view details

WHILE loops and iteration and part and parcel of any programming language and SQL is no different. This video focuses on how to iterate through resultsets and rows and the semantics of the WHILE loop (along with BEGIN and END).

• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 300 (Intermediate)
• Length: 18:05 (14.2MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video

New Transact SQL Video Tutorial: Part 3 - Using EXISTS to Control Execution In an IF Statement

Part 3 - Using EXISTS to Control Execution In an IF Statement - view details

EXISTS is a fundamental part of a SQL programmer's arsenal. This video, part three in our series on using control-of-execution statements, explores using IF EXISTS to drop/create objects and detect data.

• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 300 (Intermediate)
• Length: 14:22 (9.79MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video

New Transact SQL Video Tutorial: Part 2- Using IF Statements to Control Execution in Scripts and Stored Procedures

Part 2- Using IF Statements to Control Execution in Scripts and Stored Procedures - view details

This video explores more uses of IF statements to control the flow of your SQL code inside stored procedures. You'll learn about using IF EXISTS and more in this video on basic SQL programming.

• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 300 (Intermediate)
• Length: 16:30 (11.2MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video

New Transact SQL Video Tutorial: Part 2 - Identity Columns - When Should I Use an Identity Column?

Part 2 - Identity Columns - When Should I Use an Identity Column? - view details

Our second video in the series on using IDENTITY/sequencing columns, this video focuses on when you might consider using a system-generated identifier.

• Category: Table Design - Datatypes, Constraints, IDENTITY Columns, Normalization, and More
• Skill Level: 100 (Beginner)
• Length: 11:00 (8.18MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video