Answer Posted / sunny kumar rana

1) A stored procedure can accept parameters while a trigger
cannot.
2) A trigger can’t return any value while stored procedures
depand on condition.
3) A trigger is executed automatically on some event while
a stored procedure needs to be explicitly called.
4) Triggers are used for insertions, update and deletions
on tables while stored procedures are often using
independently in the database.
5) A trigger cannot be written in a stored procedure.
However, the reverse is not possible.

What is partition by in sql?

1050

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

949

---

Does truncate table reset auto increment?

978

---

Can we use the cursor's to create the collection in PL/SQL?

1006

---

Why do we use partitions in sql?

1033

---

What are the operators in sql?

1003

---

What is pls_integer in pl sql?

1074

---

What are string functions in sql?

1220

---

What are the benefits of pl/sql packages?

1092

---

what are date and time data types? : Sql dba

962

---

What is a record in a database?

1042

---

What are instead of triggers?

1029

---

What is the best free sql database?

1041

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1107

---

what is rollback? : Sql dba

1081

---