What is a covering index?

0 Answers  

---

What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

---

Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

Define primary key?

0 Answers  

---

What have included columns when we talk about sql server indexing?

0 Answers  

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

What is proper subset of candidate key?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---