Explain trigger and trigger types?

0 Answers  

---

What is a stored procedure?

3 Answers  

---

What is shrink log file?

0 Answers  

---

What are the database roles? : sql server security

0 Answers  

---

How to list all user defined functions in the current database?

0 Answers  

---

---

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

---

Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  

---

Explain how to use linked server?

0 Answers  

---

Can we do dml on views?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---