UPDATE mytable set mycolumn = (mycolumn + 1)%2

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 / ajay sharma

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

Answer Posted / ajay sharma

UPDATE mytable set mycolumn = (mycolumn + 1)%2

Is This Answer Correct ?

21 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rs.exe utility?

162

Find first and last day of current month in sql server

1080

what is the difference between Tabular and Matrix report?

179

What is a rownum?

1056

Explain acid?

1140

Explain the use of containers in ssis and also their types?

1015

List some major differences between triggers and stored procedures?

977

What is indexing a document?

1084

Name the different type of indexes in sql?

1012

What does sql server mean?

1158

What is dirty read?

1134

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1120

What is ddl and dml commands?

957

How self join is different from outer join?

1173

How to insert multiple rows with one insert statement in ms sql server?

1176