Expert SQL Server 2005 Development

Chapter 7. Dynamic T-SQL

When designing any application, the general goal is to create a great user experience; if users don't like the application, they won't use it, and if users won't use it, chances are it won't sell. So pleasing users is incredibly important to keeping software businesses afloat. Once this goal has been established, the question then becomes, "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. ...