BETWEEN 运算符

谓词 x [NOT] BETWEEN lower AND upper 可在 WHILE 循环的 表达式中使用。其工作方式与 [ NOT ] ( x >= lower AND x <= upper) 相同。

示例

示例代码CREATE FUNCTION between_03(x INT)RETURNS result NVARCHAR(1) ASBEGINDECLARE idx INT = :x;result = 'O';WHILE :idx BETWEEN 5 AND 15 DOidx = :idx + 1;result = 'X';END WHILE;END;