sql server 随机生成布尔值

SELECT CAST(ROUND(RAND(),0) AS BIT)

或者

SELECT ROUND(RAND(),0)