How can you swap values between two rows in a table using single- SQL statement?

1 Answers   Tavant Technologies, Virtusa,

---

Is sql server a database?

0 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

What does REVERT do in SQL Server 2005?

0 Answers   HCL,

---

Explain the properties of subqueries in sql server?

0 Answers  

---

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

What is key set driven?

0 Answers  

---

What is a partition key?

0 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

What is difference between after and before?

0 Answers  

---

Can foreign key be deleted?

0 Answers  

---