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
- 9543 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
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How to create sub reports?
How to write character string constants or literals in ms sql server?
Do you know exporting and importing utility?
What is a transactions?
Explain log shipping?
What is the use of group by clause?
How do I delete a sql server database?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
Explain “row_number()” in sql server with an example?
What is @@rowcount in sql?
What method is used by the Command classes to execute SQL statements that return single values?
Explain the properties of sub-query in sql server?
What is precedence constraint?
What options are available to audit login activity? : sql server security
