刚入门，问一个简单的sql

Question

sqlserver的 &
位运算 and

Answer 1

SELECT DISTINCT CatalogID FROM Rights WHERE (IsUser=1 AND BITAND(RVal,2)>0 )
用sqlserver的写法是怎么的？

Answer 2

SQL> select bitand('1','0') from dual;BITAND('1','0')
---------------
              0SQL> select bitand('0','0') from dual;BITAND('0','0')
---------------
              0SQL> select bitand('1','1') from dual;BITAND('1','1')
---------------
              1位与

Answer 3

SQL> select utl_raw.bit_and('0001','0010') from dual;UTL_RAW.BIT_AND('0001','0010')
--------------------------------------------------------------------------------
0000SQL> select utl_raw.bit_and('1101','0100') from dual;UTL_RAW.BIT_AND('1101','0100')
--------------------------------------------------------------------------------
0100

Answer 4

呵呵，你现在知道了bitand是什么意思，然后到sqlserver去问相应写法不是更好吗？
毕竟本版是oracle版啊。