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.

How to loop through result set objects using mssql_fetch_array()?

1133

---

What does man by sql wildcard characters in sql server?

1104

---

What is the advantage of sql server?

1080

---

Explain what is scheduled job and how to create it?

1023

---

Explain what is it unwise to create wide clustered index keys?

1023

---

what is the difference between a primary key and a unique key? : Sql server database administration

1041

---

What is difference between delete and truncate commands?

1170

---

What is the most common type of join?

1038

---

Explain indexed views?

1027

---

What is the latest version of microsoft sql server?

1116

---

What is a print index?

933

---

Define inner join in sql server joins?

1125

---

How you can get a list of all the table constraints in a database?

999

---

Explain what is the difference between union and union all?

1070

---

what's the maximum size of a row? : Sql server database administration

1163

---