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
- 9859 Views
- PMAM IT Services, TCS, I also Faced
- E-Mail Answers
Answer Posted / vicky saini
Update (tablename) set (coulmn name)=1 where (coulmn name)
=0
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How to change the ownership of a schema in ms sql server?
What is query parameter in ssrs?
What are different types of subquery?
What action plan is preferred if sql server is not responding?
How would you choose between a clustered and a non-clustered index?
What is the difference between varchar and varchar types?
What is the library index called?
How do I delete a sql server database?
Explain subquery and state its properties?
How do we know if any query is retrieving a large amount of data or very little data?
Explain what is log shipping?
Can a trigger be created on a view?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Which Model uses the SET concept
What is normalization and denormalization in sql server?
