New Transact SQL Video Tutorial: How to Avoid Using a Temp Table When Constructing Dynamic SQL (Looping) to Build Arrays and Lists

How to Avoid Using a Temp Table When Constructing Dynamic SQL (Looping) to Build Arrays and Lists - view details

Maybe you need to create a comma-separated list of every column in a table or every value in a row, how would you do it? Most people would immediately think of using a temporary table (a temp table) or a table variable and iterating through the rows one by one, concatenating a local variable (possibly by using dynamic sql), and then returning the final variable. This video shows a more set-based approach and walks you through the execution and logic. Want to avoid using a cursor or staging table? Check out this alternative and, if you're lucky, it can help you avoid row-by-row thinking!

• Category: User-Defined Functions (UDFs) in SQL Server
• Skill Level: 400 (Intermediate - Advanced)
• Length: 13:48 (9.17MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos

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