Answer Posted / swetha

There are 2 types of triggers

Insted of trigger:
Instead Of Trigger fires an operation instead of performing
user specified operation.


After trigger: After Trigger fires an operation after any
insert,update,delete operations performed on a table.

What are different types of database indexes?

524

---

Explain different types of Normalization.

593

---

How to execute stored procedure and set temp table in sql server?

550

---

What is the difference between varchar and varchar types?

559

---

How do I view a stored procedure in sql server query?

533

---

---

What is a DBMS, query, SQL?

574

---

what's sql server? : Sql server database administration

494

---

What is the cpu pressure?

562

---

How to delete all rows with truncate table statement in ms sql server?

482

---

What is the difference between having clause and where clause in sql server?

566

---

how many triggers you can have on a table? : Sql server database administration

486

---

How to get nth highest salary from employee table.

613

---

Explain the Ways to improve the performance of a sql azure database?

64

---

What are the advantages to use stored procedures?

565

---

What are click through reports?

99

---