Answer / plabana

1.StoreProcedure may return avalue may not return a value
but Function returns the value.
2.SttoreProcedure can be called independently using exec
keyword ,Function are called using select stmt.
3.StoreProcedure can create a table but can't return a table
where as Function can return a value.
4.Transaction related stmt can be handeled by StoreProcedure
Where as it can;t be handeled by Function.

Answer / saraswathi muthuraman

Function :

1) Must return a single value. Only one value can be return
from a function.

2) Can be called from a sql(insert,update,delete) or
assignment st.U can't execute the function directly.

3) Can have DML,DDL,TLC inside function. But those function
can not be called from a sql.

Procedure :

1) Procedure can return multiple values.Procedure is
optional to return a value.

2) Can be executed directly and u can't called procedure
from sql.

3)Can have DML,DDL,TLC inside Procedure.

Answer / hitesh

1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing

Answer / saurav kumar

1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.

2) Stored proedure may or may not return a value but
function must return a value.

3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.

How is foreign key related to primary key?

0 Answers  

---

Explain where clause?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---

How you can get the list of largest tables in a database?

0 Answers  

---

---

What are the different types of subquery?

0 Answers  

---

Explain what are magic tables in sql server?

0 Answers  

---

What is a stored procedure?

3 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

How do I create an extended event in sql server?

0 Answers  

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---