Answer Posted / ghanshyam vrema

1. SP may Return a value but Trigger Not,
2. In SP you can pass parameter But in trigger you can't
3. we explicitly call the Sp when Trigger are implicitly
fired
4. you can write a sp in Trigger but in a Trigger you cant
write SP.
5. Trigger written on an individual Table or View where SP
is written for an Database

how can u get last observation in an unknown dataset ?

2395

---

Explain a checkpoint?

985

---

How do I setup a sql server database?

1016

---

What is sql server profiler trace data file?

1060

---

What do you mean by authentication modes in sql server?

1039

---

Explain few of the new features of sql server 2008 management studio

868

---

Name 3 ways to get an accurate count of the number of records in a table?

981

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

895

---

List all the types of user-defined functions?

1012

---

What does it mean to invest in the index?

913

---

how to do partition in sqlserver

2418

---

How many types of objects are there?

948

---

What is sql stored procedure?

1025

---

What are the different type of replication in sql server?

941

---

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

958

---