Re: 2005 Stored Procedure Question - How to pass in additional LIKE conditions
Posted by --CELKO-- on 12/18/07 16:36
>> More control over the user - don't see how <<
The user can be limited to how many search terms he can input at one
time. If you use dynamic SQL, they can go wild and strangle the
database with hundreds or thousands of requests. It is also easier
to apply edits to the @search_term_# parameters, such as trimming,
upper or lower casing, replacing characters, etc.