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
9846 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 the different types of backups available in sql server? : Sql server database administration

931

What are “lost updates”?

1001

What is the maximum size of sql server database?

1011

Explain what are the different index configurations a table can have?

1113

Does view occupy space?

946

How global temporary tables are represented and its scope?

977

What is query optimization process?

1015

What is the default fill factor value?

1080

what is a correlated sub-query? : Sql server database administration

942

What is a user-defined function in the sql server and what is its advantage?

1105

What are security principals used in sql server 2005?

988

Suggest a method of joining two tables.

1157

What is pessimistic concurrency?

976

What is Replication?

1052

How to rebuild the master database?

1081