存储里根据权限或其他内容来控制单价显示与否(惊险经历)

    技术2022-05-11  16

    (case when ' + @sql29 + ' =0 then 0 else unprc end) as 單价  //这句还有待验证

    case ' +@sql29+ ' when 1 then '+''''+'0'+''''+' when 2 then '+''''+'无'+''''+' end as 單价   //正确

    set @strSql='select pono as 采購單號,vendor as 供應商,part as 料號,specification as 料品名稱規格,unit as 單位,qty as 數量,recqty as 驗收總數,case '+@sql29+' when 1 then unprc else '+''''+'0'+''''+' end as 單价

    //存储里这个也正确


    最新回复(0)