Metadata-driven SQL code generation

October 2022’s T-SQL Tuesday is hosted by Steve Jones (b|t) – thanks Steve 😊. Steve’s invitation this month is to write about using dynamic SQL – that is, T-SQL code that is built up from text strings and then executed as code.