One of the most common, versatile, and useful ways to implement Dynamic SQL is when performing complex searches. Consider your favorite web sites and the search functionality provided in each. For some, the search may be simple: You go to the single text box in the top-right corner, enter some text, and get your results. Other searches—such as searching for a hotel, flight, or car rental—can involve dozens (or more) of optional parameters. Dynamic SQL can allow you to pare down your search queries in order to only process what is needed. In addition, you can greatly customize the search, as well as the data ...
© Ed Pollack 2016
Edward Pollack, Dynamic SQL, 10.1007/978-1-4842-1811-2_3
3. Large Scale Searching
Edward Pollack1
(1)Albany, New York, USA
Get Dynamic SQL: Applications, Performance, and Security now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
