什么是按类别,部门等排序的查询 [英] What is the Query to sort by category ,department etc
本文介绍了什么是按类别,部门等排序的查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
查询按类别,部门等排序...我需要的是,如果我选择类别,它应该按它排序,如果按部门排序,如果两者都这样......
Query to sort by category ,department etc...What i need is if i select category it should sort by it and if department by it and if both that way...
推荐答案
我相信动态查询的强大功能;)
在存储过程中构建动态SQL [ ^ ]?
I believe in power of dynamic queries ;)
Building Dynamic SQL In a Stored Procedure[^]?
这篇关于什么是按类别,部门等排序的查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文