Answer Posted / aditi yadav

in addition to above answers -
1. Functions can be called inside procedure but procedure cannot be called inside functons.
2. Functions compiled every time when we call them whereas procedure compiles only once & can be called again and again without being compiled.
3. we can user functions in select statement but cannot use procedure.
4. Inside function we cannot user DML commands but inside procedures we can use DML commands.

What is difference between table and view?

1063

---

Can we group by two columns in sql?

999

---

Can we perform dml on view?

1047

---

Does asenumerable execute the query?

1050

---

What are the subsets of sql?

1137

---

How do I find duplicates in a single column in sql?

1022

---

Describe types of sql statements?

1061

---

how to include character strings in sql statements? : Sql dba

1077

---

What is the difference among union, minus and intersect?

1002

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1003

---

How show all rows in sql?

1016

---

What is snowflake sql?

1079

---

Can we have two clustered index on a table?

1025

---

How many types of privileges are available in sql?

1350

---

Is crud a cuss word?

1036

---