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
- 9843 Views
- PMAM IT Services, TCS, I also Faced
- E-Mail Answers
Answer Posted / vicky
Update test01 Set num =(case num when 1 then 0 when 0
then 1 else 3 end)
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
plss anybody specify tha constrian management system in dbms
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is difference between unique and primary key?
What is a cache in ssrs?
Explain the different types of joins?
What do you understand by replication in sql server?
What is the difference between TRUNCATE and DROP?
What is SQL Server?
What is 2nf in normalization?
What do you mean by tablesample?
What is stored in the mssqlsystemresource database? : sql server database administration
What is merge statement?
Does the unique constraint create an index?
Explain how to integrate the ssrs reports in application?
