Answer / rakesh

mojor difference is
function must return a value but a
procedure may or may not return a value

Answer / a.suresh

1.Stored Procedure return 0 to nth value where as function
return only one value which is must.
2.we can't use the stored procedure in select select
statement where as function can be used in the select statement.
3.we can use all the dml(insert,update,delete) commands in
stored procedure where as select statement only used in
functions.
4.we can use try catch in stored procedure where as in
functions cant.
function must be used with its schema where as stored
procedure used with out schema name
ex.dbo.function name

Answer / g.ashok

Stored Procedure need not to return a value.
Function should return a value.

How can sql injection be stopped? : sql server security

0 Answers  

---

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

what are the types of indexes? : Sql server database administration

0 Answers  

---

What is the user of Primary key?

0 Answers  

---

What's the maximum size of a row?

4 Answers   IBM,

---

What do you know about system database? : SQL Server Architecture

0 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

How to implement service broker?

0 Answers  

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

Explain how many types of relationship?

0 Answers  

---

What are the 10 characteristics of data quality?

0 Answers  

---

What is the minimum recommended amount of ram for sql server 2012 enterprise?

0 Answers  

---