Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 9559 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
How to create stored procedures with parameters in ms sql server?
How to drop existing views from a database in ms sql server?
1 01 101 01010
When would you use it?
Explain what is it unwise to create wide clustered index keys?
can SSRS reports Cache results?
What do you mean by sql server 2005 express management tools?
What are the new data types are introduced in sql 2000?
Describe how to use the linked server?
what is denormalization and when would you go for it? : Sql server database administration
What is the full form of ddl?
What is system stored procedures?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Can we perform backup restore operation on tempdb? : sql server database administration
What is the difference between insensitive and scroll cursor?
