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

What is after dml trigger?

1016

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1145

---

Explain different types of collation sensitivity?

982

---

Explain the purpose of indexes?

976

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

989

---

What is the server name for sql management studio?

1022

---

What is executereader?

952

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1058

---

What are alternate keys?

979

---

What is the process of indexing?

1007

---

What are the five characteristics of good data?

918

---

What is outer join in sql server joins?

1116

---

What is recompile sql server?

1036

---

What is named query? : sql server analysis services, ssas

964

---

What are the types of database schema? : sql server analysis services, ssas

1132

---