quizzes

Table Value Constructors in TSQL

Table Value Constructors in TSQL

Last week’s quiz was on Table Value Constructors in TSQL.

Table value constructors let you create a dataset on the fly. These can occasionally be useful in writing queries, but I think playing with them has another benefit: they provide a simple, lightweight framework to let you develop your ability to think in sets.

CROSS APPLY in T-SQL: Why to APPLY

CROSS APPLY in T-SQL: Why to APPLY

Michelle asked a great question:

In your own words, why would one want to use a cross apply operator rather than a join operator? I’m old school, and I’m just not getting why a cross apply would be so much better to use than a join.