Can anyone answer my question please as i am new to SQL server:-
1) what is a similar function in SQL server which matches BITAND() in Oracle.

2) How to do a outer join in SQL server when one column is constant, for ex: the below join works fine in Oracle, when i am trying to convert in to SQL server getting the following syntax error (150)
Error: Both terms of an outer join must contain columns.