Use Bitwise Operators in T-SQL to do AND/OR/XOR (&/|/^) between two or more bit/integer variables.
You can use z = x and y in VB where x,y,z is Boolean, in T-SQL:
SET @z =
@x & @y
Or swap two Integer variables:
DECLARE @X int, @y int
SET @x = 5
SET @y = 6
SELECT @x as X, @y as Y
SET @x = @x ^ @y
SET @y = @y ^ @x
SET @x = @x ^ @y
SELECT @x as X, @y as Y