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.

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

---

What is difference between join and natural join?

0 Answers  

---

What are difference between Cluster index and Non-Cluster index?

0 Answers   QuestPond,

---

What is dknf in normalization form?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

What is the difference between varchar and nvarchar datatypes?

0 Answers  

---

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

What are date and time data types in ms sql server?

0 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

What the different types of Replication and why are they used?

0 Answers  

---

What is lock escalation? : sql server database administration

0 Answers  

---