如何在SQL Server 2012中更改此查询

本文介绍了如何在SQL Server 2012中更改此查询的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 SELECT b.trn_sno，b.bill_date，b.bill_bno，b.pt_name，b.age，b.sex，iif（d.doct_nm Is Null，''，d.doct_nm） ，& _ b.amount，iif（b.chk_free = 1，b.amount，0），iif（b.chk_free = 1,0，b.amount），iif（iif（b.app_ref为null， 0，b.app_ref）= 1，iif（iif（b.rec_ref为null，0，b.rec_ref）= 1，'Refunded'，'Approved for Refund'），''）FROM rec_all as b LEFT JOIN医生as d ON b.doct_id = d.doct_id WHERE& txtfld& 和& _ b.rw = 0 and b.co_code ='& CoCode& 'ORDER BY b.r​​ec_ref，b.bill_date，b.trn_sno 我尝试过： MS ACCESS QUERY到SQl Server 2012更改解决方案 "SELECT b.trn_sno, b.bill_date, b.bill_bno, b.pt_name, b.age, b.sex, iif(d.doct_nm Is Null,'',d.doct_nm), " & _"b.amount, iif(b.chk_free=1,b.amount,0), iif(b.chk_free=1,0,b.amount), iif(iif(b.app_ref is null,0,b.app_ref)=1,iif(iif(b.rec_ref is null,0,b.rec_ref)=1,'Refunded','Approve for Refund'),'') FROM rec_all as b LEFT JOIN doctors as d ON b.doct_id=d.doct_id WHERE " & txtfld & " and " & _"b.rw=0 and b.co_code='" & CoCode & "' ORDER BY b.rec_ref, b.bill_date, b.trn_sno"What I have tried:MS ACCESS QUERY TO SQl Server 2012 change 解决方案 这篇关于如何在SQL Server 2012中更改此查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！