New Transact SQL Video Tutorial: Variables - Understanding the Difference Between Using SET and SELECT to Assign Values

Variables - Understanding the Difference Between Using SET and SELECT to Assign Values - view details

This video is designed to help you understand when you should use SET @Variable = value and SELECT @Variable = value. For new people coming into T-SQL programming, it's often quite confusing when to use SET vs. SELECT for variable assignment.

---

• Source: http://www.LearnTransactSQL.com
• Category: Commonly Used T-SQL Constructs: Datatypes, Type Conversion, Variables, System Functions and Views and more
• Skill Level: 200 (Beginner - Intermediate)
• Length: 11:02 (7.8MB)
• 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

---

Keywords Associated with this video: assign variable from database