How can I declare a Boolean parameter in SQL statement?

Question

Answer

The same way you declare any other variable, just use the bit type:

DECLARE @MyVar bit
Set @MyVar = 1  /* True */
Set @MyVar = 0  /* False */

SELECT * FROM [MyTable] WHERE MyBitColumn = @MyVar

Note this is semantically different from a true boolean. The 1/0 values won’t always just map to true/false the way you might expect.

Accepted Answer

The same way you declare any other variable, just use the bit type:DECLARE @MyVar bitSet @MyVar = 1  /* True */Set @MyVar = 0  /* False */SELECT * FROM [MyTable] WHERE MyBitColumn = @MyVarNote this is semantically different from a true boolean. The 1/0 values won&#8217;t always just map to true/false the way you might expect.

Advertisement

Answer