基于SQL Server的动态多条件查询方案

Implementation of Dynamic Multi-criteria Query Solution Based on SQL Server

目前越来越多的系统提供的搜索功能更加全面和智能。当涉及到的搜索条件较多,并且是由用户动态选择输入时,传统的算法会导致代码复杂、效率低,以及维护困难。提出一种新的处理方案,可以在提高执行效率的同时,有效地降低代码复杂度,使系统更加容易维护和扩展。

At present, more and more systems provide more comprehensive and intelligent search function. When the searchcondition is complex and is confirmed by the user＇s dynamic choice input, the tradition algorithm will lead to complicatedcode, low efficiency and complex maintenance of systems. This paper presents a new method which can improve the efficiency, reduce the complexity of the code and make it easier to maintain and extend the system.