can an order by clause be used in a creation of a view?

0 Answers  

---

What does the update command do?

0 Answers  

---

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

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   PMAM IT Services, TCS,

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,

---

What is optimization and its types?

0 Answers  

---

What do I need to start working with sql studio? : sql server management studio

0 Answers  

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---