Answer Posted / amar

triggers is a block of code where is fired to do something action for insertion or delation of varioue t- sql statement........ where triggers are automatically fired.........

stored procedure is a predefined data types which is stored in a database............ stored procedure has to fire...........

What are the recovery models in sql server 2000?

929

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1138

---

Explain optimistic and pessimistic concurrency?

943

---

between cast and convert which function would you prefer and why?

920

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

989

---

What are the results of running this script?

869

---

What is resource governor?

931

---

How to create a local temporary stored procedure?

954

---

Can group functions be mixed with non-group selection fields in ms sql server?

898

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1004

---

How to implement service broker?

936

---

How can you list all the columns in a database?

891

---

Is it possible to update the views? If yes, how, if not, why?

980

---

Can a table be created inside a trigger?

929

---

What are the built in functions in sql server?

925

---