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
- 10039 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 you please differentiate between a primary key and a unique key?
Explain indexes disadvantages?
What types of Joins are possible with Sql Server?
Do you know what is difference between stored procedure and user defined function?
What is a not null constraint?
What is the process of normalization?
Write a query to find 5th highest amount paid from the customer table.
What is the difference between a stored procedure and a user defined function?
What is normalization 1nf 2nf 3nf?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Define views.
Explain the difference between function and stored procedure?
How do I find query history in sql server?
What is best institute to Learn DotNET And SQL in chennai?
What is stretch database in sql server?
