O'Reilly logo

Dynamic SQL: Applications, Performance, and Security by Edward Pollack

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

© Ed Pollack 2016

Edward Pollack, Dynamic SQL, 10.1007/978-1-4842-1811-2_3

3. Large Scale Searching

Edward Pollack

(1)Albany, New York, USA

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required