新人求解
一个视图:
SELECT *, CAST(TatolMark AS float) / CAST(MarkTimes AS float) AS Mark
FROM Artis s
当MarkTimes 为0的时候,会报错,如何避免
[解决办法]
SELECT *, CAST(TatolMark AS float) / case when CAST(MarkTimes AS float)=0 then null else CAST(MarkTimes AS float) end AS Mark
FROM Artis s
