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..

what is normalization? what is denormalization?

9 Answers   Satyam,

---

How to view the error log for any specific instance? : sql server database administration

0 Answers  

---

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

---

What are binary string data types in ms sql server?

0 Answers  

---

write coding for importing sql data into a word excel...

1 Answers   Oracle,

---

What is the difference between value type and reference type?

0 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

What is an extended Stored Procedure?

1 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

0 Answers  

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  

---