SELECT @v1 = CAST( (@v2 > 0) AS INT)
SELECT @v1 = CAST(CASE WHEN @v2 > 0 THEN 1 ELSE 0 END AS BIT)
@v1
BIT
SELECT @V1 = IIF ( @V2 > 0, 1, 0 )
SELECT @v1 = CAST(CASE WHEN @v2 > 0 THEN 1 ELSE 0 END AS BIT)
代替(假设转换甚至是必要的;如果@v1
已声明为BIT
,则隐式转换会自动处理它)。 - Jeroen Mostert