Explain trigger and trigger types?

0 Answers  

---

Why main is user defined function?

0 Answers  

---

What do you understand by SQL*Net?

0 Answers   Tech Mahindra,

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

What are user-defined functions (udfs) in sql server?

0 Answers  

---

---

can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.

0 Answers  

---

What is correlated subquery in sql server?

0 Answers  

---

What are the advantages of using cte?

0 Answers  

---

How do database indexes work?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

---

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 Answers  

---