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
9544 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

Explain something about security and SQL Azure?

110

What are sub reports and how to create them?

124

Define inner join? Explain with an example?

924

Which is faster statement or preparedstatement?

890

Where in ms sql server is ’100’ equal to ‘0’?

1017

Explain query editor regions

1003

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2424

What are the types of subscriptions in SQL Server replication?

961

Can we check locks in database? If so, how can we do this lock check?

893

What are the restrictions while creating batches in sql server?

1004

what is spatial nonclustered index

943

How to connect sql server management studio express to sql server 2005 express?

966

What are key constraints?

927

How to use subqueries with the exists operators in ms sql server?

1058

Do you know spatial data types - geometry and geography in sql server 2008?

969