Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

What is a unique key constraint?

0 Answers  

---

Why should one not prefix user stored procedures with ‘sp_’?

0 Answers  

---

What is an entity-relationship diagram (erd)?

0 Answers  

---

Explain about merge replications?

0 Answers  

---

---

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

---

What is explicit cursors?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---