what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

What is an expensive query?

0 Answers  

---

What are magic tables in sql server?

0 Answers  

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

What is t-sql script to take database offline – take database online.

0 Answers  

---

Difference between primary key and clustered index?

0 Answers  

---

What are database states in ms sql server?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

How use inner join in sql server?

0 Answers  

---

What is normalization process?

0 Answers  

---

Difference between server.transfer and server.execute method?

2 Answers  

---