using if statement how to replace values

Question

I have two tables,

Database 1:

Table 1:

• Id -001(int)

• Name -xxx(varchar)

• Male -0 (bit)

• Female-1 (bit)

Database 2:

Table 2:

• Id -1 (int)

• Ca.Name-yyy (varchar)

• Gender - M or F (varchar)

These are my tables. I want to update data from database2, Table 2 to database1, table1. So i create update query. But I have problem with Gender field

Select 'UPDATE T1
 SET T1.MALE ='+ CASE WHEN r.Gender = 'M' THEN 0 ELSE 1 END

 FROM T2 As r

In the below code, what I starred I have a doubt how to use if statement here. Any one understand rectify my problem?

Answer 1

Use case when for this purpose.

Follow this question :

SQL Server: CASE WHEN OR THEN ELSE END => the OR is not supported

CASE  
  WHEN GENDER='M' THEN 0 
  ELSE 1 
END 

This can be in your case.

For more syntax details: CASE (Transact-SQL)