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
- 9752 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 move database physical files in ms sql server?
what do you understand by change data capture?
How do I view views in sql server?
What are commit and rollback in sql?
When I run the sql server 2000 setup, it just hangs. What do I do?
what kind of lan types do you know? : Sql server database administration
What is nonclustered index with included columns ?
Explain the properties of a relational table?
Can I use sql azure as a backup with log shipping or database mirroring?
What program is used to store the data source file?
Explain the steps needed to create a scheduled job?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What happens if an integer is too big for int date type?
How to drop an existing schema in ms sql server?
What is collation?
