Update test01 Set num =(case num when 1 then 0 when 0 then 1 else 3 e

Consider a table with 8 rows 4 rows contains value 0 and 4
rows contains value 1.Now write a single update query to make
all 0's as 1 and all 1's as 0

Question Posted / vicky

7 Answers
9763 Views
PMAM IT Services, TCS, I also Faced
E-Mail Answers

Answer Posted / vicky

Update test01 Set num =(case num when 1 then 0 when 0
then 1 else 3 end)

Is This Answer Correct ?

10 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you Implement SSIS Packages in your Project?

1910

Can sql server 2016 run on windows 7?

904

What stored by the master? : sql server database administration

1087

Can we call stored procedure in trigger?

935

how can a database be repaired? : Sql server administration

957

What is the xml datatype?

1032

What is data source view or dsv? : sql server analysis services, ssas

986

What is difference between sql and sql server?

976

Create and insert into temp table in sql server?

1009

Explain unique key in sql server?

997

What is the optimization being performed in oracle and SQL Server?

1033

What is the query and subquery?

1062

Describe different Processing Modes offered by SSRS?

246

Does group by sort data?

884

What is bcnf normalization form?

1097