bozong
V2EX  ›  问与答

请教个 sql 问题,通过这个 sql 怎么写个函数

  •  
  •   bozong · May 26, 2016 · 1764 views
    This topic created in 3830 days ago, the information mentioned may be changed or developed.
    select distinct case ISNULL(p.iscomment,0) when 0 then '未评价' else '已评价' end zhuangtai from piproject p
    left join PiEntpriseContacts s on p.entpriseid=s.entpriseid and s.enableflag=1
    where 1=1 and p.enableflag=1 and (p.estate = 13 or p.PassNodeId=11313)
    and p.CreateOn > dateadd(month,-3,GETDATE()) and (p.Mobile = '{0}' or s.mobile='{0}') and p.iscomment is null


    {0}为变量
    11 replies  •  2016-05-27 07:47:32 +08:00
    zhangshu
    zhangshu
    May 26, 2016 via Android
    1
    我记着变量传进去不是要有 @Mobile 的吗?难道是我记错了!
    bozong
    bozong
    OP
    May 26, 2016 via iPhone
    2
    @zhangshu 输入的话{0}换成 @参数 但是不知道怎么输出
    bozong
    bozong
    OP
    May 26, 2016
    3
    //////////
    zhangshu
    zhangshu
    May 26, 2016 via Android
    4
    (Mobile=@Mobile)输入,输出:(exec ‘@Mobile :你要查的东西’)@Mobile :变量
    zhangshu
    zhangshu
    May 26, 2016 via Android
    5
    好像是这样,你试试
    bozong
    bozong
    OP
    May 26, 2016
    6
    @zhangshu 我看看
    bozong
    bozong
    OP
    May 26, 2016
    7
    @zhangshu 是在 sqlserver 里面创建函数
    zhangshu
    zhangshu
    May 26, 2016 via Android
    8
    对啊,你不是在你的数据库中,用的可编程性吗?
    bozong
    bozong
    OP
    May 26, 2016 via iPhone
    9
    @zhangshu 标量函数吗
    bozong
    bozong
    OP
    May 26, 2016 via iPhone
    10
    @zhangshu 方便给个扣扣吗?嘿嘿
    zhangshu
    zhangshu
    May 27, 2016 via Android
    11
    1909622960
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1039 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 27ms · UTC 22:59 · PVG 06:59 · LAX 14:59 · JFK 17:59
    ♥ Do have faith in what you're doing.