explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

What is the beast way to write CTE in SQL Server ?

0 Answers   HCL,

---

Do you know what is rank function?

0 Answers  

---

Define self join in sql server joins?

0 Answers  

---

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

0 Answers  

---

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

Describe the functionalities that views support.

0 Answers  

---

What is a transactions?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---