Dynamic T-SQL

Abstract

The general objective of any software application is to provide consistent, reliable functionality that allows users to perform given tasks in an effective manner. The first step in meeting this objective is therefore to keep the application bug-free and working as designed, to expected standards. However, once you’ve gotten past these basic requirements, the next step is to try to create a great user experience, which raises the question, “What do the users want?” More often than not, the answer is that users want flexible interfaces that let them control the data the way they want to. It’s common for software customer support teams to receive requests for slightly different sort orders, filtering mechanisms, or outputs for data, making it imperative that applications be designed to support extensibility along these lines.