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.

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What is field with example?

0 Answers  

---

Which Model uses the SET concept

0 Answers   Infosys,

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

---

Why use identity in sql server?

0 Answers  

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

CREATE a table from another table

2 Answers  

---

What is normalization and its types?

0 Answers  

---

What are the recovery models in sql server 2000?

0 Answers  

---

What is partition in sql server?

0 Answers  

---

Explain the working of sql privileges?

0 Answers  

---