六狼论坛

 找回密码
 立即注册

QQ登录

只需一步,快速开始

新浪微博账号登陆

只需一步,快速开始

搜索
查看: 59|回复: 0

SQL case statement

[复制链接]

升级  14%

19

主题

19

主题

19

主题

秀才

Rank: 2

积分
71
 楼主| 发表于 2013-2-7 17:27:13 | 显示全部楼层 |阅读模式
selectcase    when function_order='23' then '232323'    when function_order<5 then 'Small'else 'BigGGG'end as DDD,function_id as IDD,case    when function_name='图书录入' then 'TSLR'        else '~~~~'end as '~~',function_url as urlfrom d_function where 1=1+++++++++++++++++++++++++++++++++++++++++++++DDD    IDDD     ~~      urlSmall1TSLRhttp://book.comSmall2~~~~welcome\fun2.htmlSmall3~~~~welcome\fun3.htmlSmall4~~~~welcome\fun4.htmlBigGGG5~~~~welcome\fun5.htmlBigGGG6~~~~welcome\fun6.htmlBigGGG7~~~~welcome\fun1.htmlBigGGG8~~~~welcome\fun2.htmlBigGGG9~~~~welcome\fun3.htmlBigGGG10~~~~welcome\fun4.htmlBigGGG11~~~~welcome\fun5.htmlBigGGG12~~~~welcome\fun6.htmlBigGGG13~~~~welcome\fun1.htmlBigGGG14~~~~welcome\fun2.htmlBigGGG15~~~~welcome\fun3.htmlBigGGG16~~~~welcome\fun4.htmlBigGGG17~~~~welcome\fun5.htmlBigGGG18~~~~welcome\fun6.htmlBigGGG19~~~~http://BigGGG20~~~~http://BigGGG21~~~~BigGGG22~~~~http://jjjjjjjjjjjjjjjj.com23232323~~~~http://dfdf
您需要登录后才可以回帖 登录 | 立即注册 新浪微博账号登陆

本版积分规则

快速回复 返回顶部 返回列表