Workarounds for T-SQL Restrictions and Limitations
Level: 300 Technology Focus: Development Primary Audience: Database Developer
T-SQL Trainer Lucient Redmond, Washington
Have you ever needed to compute the minimum or maximum value over columns? How about computing row numbers with no particular order, just for uniqueness? Have you ever tried creating an ordered view? How about reusing column aliases defined in the SELECT list in other clauses like the WHERE and GROUP BY? This session describes a number of needs that are not directly supported in T-SQL, and shows how with a bit of creativity, you can address those needs.
Learn about T-SQL tips and tricks
Use workarounds for limitations and restrictions in T-SQL