Add computed boolean column SQL Server

Question

How do I add a computed boolean (bit) column to a SQL Server table that depends on two other boolean columns? (I'd prefer a SSMS solution).

I can get a computed column with the correct values by using the following:

case when ([ColumnA]=(1)) AND ([ColumnB]=(0)) then (1) else (0) end

but then the resulting column is type int which falls over when I use the data in C#

Looking around, it seems I need to use a CAST statement but I haven't managed to work out the syntax. I know this doesn't work:

cast (case when ([ColumnA]=(1)) AND ([ColumnB]=(0)) then (1) else (0) end) as bit

What should I do?

Pரதீப் · Accepted Answer · 2014-11-28 06:21:32Z

9

You misplaced the parenthesis. try this.

      Cast (CASE
               WHEN  [ColumnA] =  1  
                    AND  [ColumnB] =  0   THEN  1 
               ELSE  0 
             END AS BIT)

edited Nov 28, 2014 at 6:21

answered Nov 28, 2014 at 5:48

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mcalex Over a year ago

Wow, I thought only the case ... end was bracketed. Many thanks.

Collectives™ on Stack Overflow

Add computed boolean column SQL Server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related