sql中为什么用trunc时会出现trunc不是一个可识别的函数?
SELECT rq, ka, qymc, jk2, ck2, ba1, hx1, zc2, ddf1, qt1, bz, ISNULL(jk2, 0) + ISNULL(ck2, 0)
+ ISNULL(ba1, 0) + ISNULL(hx1, 0) + ISNULL(zc2, 0) + ISNULL(ddf1, 0) + ISNULL(qt1,
0) AS hj, yj, trunc(qt1, - 2) AS qt2
FROM v_yjqymx
运行时为什么会出现 trunc is not a recognized function name 这样的提示?望各位指点.谢谢!