Update Table1 Set Column = case when Column = 1 then 0

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 / vernold

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

Answer Posted / vernold

Update Table1 Set Column = case when Column = 1 then 0
when column = 0 then 1

Is This Answer Correct ?

5 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to rebuild the master database?

1138

Define self join?

1078

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1064

What is clustered primary key?

1082

How to replace the Query Result 'Null Value' with a text ?

1093

What is use of @@ spid in sql server?

1271

How do you open a cluster administrator?

1096

What do you mean by a Composite primary key?

1187

What is TDS(Tabular Data Stream) Gateway?

127

What is the difference between left and right outer join?

1112

What is xml datatype?

1129

Why are views required in the sql server or in any other database?

1000

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

958

What are different types of data sources?

1081

Mention the differences between substr and charindex in sql server.

1112