SQL SERVER中“&”运算符有什么用

What is the use of "&" operator in SQL SERVER

提问by Rohit Raghuvansi

What is the use of & operator in the code specified below. IS there any benefit of using & instead of "AND". Please elaborate.

下面指定的代码中 & 运算符的用途是什么。使用 & 而不是“AND”有什么好处。请详细说明。

CASE ( C.[Status] & F.[Status] & D.[Status] & DWT.[Status] & P.[Status] )
    WHEN 1
        THEN CASE ( C.IsDeleted & F.IsDeleted & D.IsDeleted & P.IsDeleted )
        WHEN 0 THEN NULL
        ELSE 7
        END
    ELSE 6
END

回答by Michael Pakhantsov

&is bit AND operation:

&是位与运算：

• &Bitwise AND

• |Bitwise OR

• ^Bitwise exclusive OR

• ~Bitwise NOT

• &按位与

• |按位或

• ^按位异或

• ~按位非

回答by SQLMenace

Bitwise AND operation, take a look at & (Bitwise AND) (Transact-SQL)in Books On Line

按位与运算，看看在线书籍中的&(Bitwise AND) (Transact-SQL)

回答by Simmo

It's a bitwise operator - AND

这是一个按位运算符 - AND

http://msdn.microsoft.com/en-us/library/ms176122.aspx

http://msdn.microsoft.com/en-us/library/ms176122.aspx