Answer Posted / avdhesh yadav

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

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

681

---

List all types of constraints in sql server?

679

---

What are trace flags and mention a few common trace flags used with sql server?

743

---

How to copy data from one table to another table?

737

---

How to rebuild all indexes on a single table?

768

---

---

Find first and last day of current month in sql server

762

---

How to create a new table in a given schema?

840

---

Can we do dml on views?

727

---

Can we add an identity column to decimal datatype?

755

---

How we can compare two database data?

685

---

Is ssrs support other database except ms sql server?

104

---

How to define the name and server for a new dsn?

721

---

What stored by the msdb?

771

---

What is the difference between dataadapter and datareader?

725

---

Is there any difference between the primary key and unique key?

744

---