我想将此查询从mySQL转换为MSSQL,请您提供帮助吗?感谢您的回复,
view_taksitmus CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost`
SQL SECURITY DEFINER VIEW `view_taksitmus`
AS (select `t`.`taksitid` AS `taksitid`,`t`.`policeid` AS `policeid`,`t`.`vade` AS `vade`,
`t`.`tutar` AS `tutar`,
if(isnull(sum(`tm`.`tutar`)),0,sum(`tm`.`tutar`)) AS `odenen`,
if(isnull(sum(`tm`.`tutar`)),`t`.`tutar`,(`t`.`tutar` - sum(`tm`.`tutar`))) AS `kalan`,
`p`.`policeno` AS `policeno`,`p`.`zeyilno` AS `zeyilno`,`p`.`yenilemeno` AS `yenilemeno`,`p`.`plaka` AS `plaka`,`p`.`doviz` AS `doviz`,`p`.`kur` AS `kur` from ((`ins_taksitmus` `t` left join `ins_takmak` `tm` on((`t`.`taksitid` = `tm`.`taksitid`))) left join `view_police` `p` on((`t`.`policeid` = `p`.`policeid`))))
这是您要寻找的吗?
CREATE VIEW view_taksitmus
AS
select t.taksitid AS taksitid
,t.policeid AS policeid
,t.vade AS vade
,t.tutar AS tutar
,CASE WHEN sum(tm.tutar) IS NULL THEN 0 ELSE sum(tm.tutar) END AS odenen
,CASE WHEN sum(tm.tutar) IS NULL THEN t.tutar ELSE (t.tutar - sum(tm.tutar)) END AS kalan
,p.policeno AS policeno
,p.zeyilno AS zeyilno
,p.yenilemeno AS yenilemeno
,p.plaka AS plaka
,p.doviz AS doviz
,p.kur AS kur
from ins_taksitmus t
left join ins_takmak tm on t.taksitid = tm.taksitid
left join view_police p ont.policeid = p.policeid