Answer / anand vanam

What is the difference between Functions and Stored
Procedures?
Answer:
1. Stored procedure supports deferred name resolution: but
Function won’t support deferred name resolution.
2. Stored procedures return always an integer value by
default zero. Where as function Scalar (single value or
table or row set)
3. Stored procedures are precompiled execution plan but
functions are not.
4. The result of the user defined function can be used with
in a sql server statement. Where as the result of stored
procedures can’t be used in sql server statements.
5. Stored procedure allows all functionality provided by a
function but the reverse is not true.
6. Functions in sql server can be one of two different types
1.scalar, 2. Table
Stored procedures are 2 types. 1. Regular sp, 2. Temporary
sp

Answer / surya

we can write store procedure without table also..but not
triggres..

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

How can you append an identity column to a temporary table?

0 Answers  

---

What is a transaction and why is it important?

0 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

Do you know what are different types of replication in sql server?

0 Answers  

---

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---

How to check status of stored procedure in sql server?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

Write down the syntax and an example for create, rename and delete index?

0 Answers  

---

What are the difference between primary keys and foreign keys?

0 Answers  

---