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.

Define tempdb database?

986

---

How we can refresh the view?

1102

---

Explain a checkpoint?

1020

---

How to filter out duplications in the returning rows in ms sql server?

1128

---

If user is owning any SQL Objects, can we drop that user

2060

---

Where are sql server usernames and passwords stored in the sql server?

1105

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

946

---

How do you delete a data source?

1002

---

What are the authentication modes in sql server? How can it be changed?

1118

---

What is a trigger in sql server?

1161

---

What do you mean by the term 'normalization'?

1192

---

Relational calculus is what type of language?

1024

---

What are difference between Cluster index and Non-Cluster index?

1067

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2579

---

Is mysql better than sql server?

1057

---