szhswl
宋针还的个人空间
见如下两SQL:
select sys_navigation_param_tb.*,
case when sys_navigation_param_tb.id in
(select sys_role_rihgts_tb.nav_param_id from sys_role_rihgts_tb where sys_role_rihgts_tb.role_id='1')
then 0
else 1 end flag
from sys_navigation_param_tb

select
case when (select count(id) from sys_role_rigths_tb) > 0 then sys_navigation_param_tb.group_name
else sys_navigation_param_tb.order_name
end
from sys_navigation_param_tb



---------------------------------------------------------------------------------------------------------------------------------
说人之短,乃护己之短。夸己之长,乃忌人之长。皆由存心不厚,识量太狭耳。能去此弊,可以进德,可以远怨。
http://www.blogjava.net/szhswl
------------------------------------------------------------------------------------------------------ ----------------- ---------
posted on 2007-12-04 14:39 宋针还 阅读(206) 评论(0)  编辑  收藏 所属分类: SQL

只有注册用户登录后才能发表评论。


网站导航: