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.

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

What is sql server query analyzer?

0 Answers  

---

Create and insert into temp table in sql server?

0 Answers  

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

Explain relational data?

0 Answers  

---

How to list all schemas in a database?

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

What is a covered index?

0 Answers  

---

What is sql sandbox in sql server?

0 Answers  

---

What are the different types of backup avaible in SQL SErver

6 Answers   Emphasis, IBM,

---

What is the order by used for?

0 Answers  

---