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 a functions and types in sql server?

0 Answers  

---

How can I enforce to use particular index?

1 Answers   Symphony,

---

what is performance tunning in sql server ? explain.

1 Answers   Thomson Reuters,

---

How will u get 5 years back record?

5 Answers  

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

How do I create a trace in sql server?

0 Answers  

---

What is normalization? Explain different forms of normalization?

0 Answers  

---

What are the steps you must follow to hide sql server instances?

0 Answers  

---

What is the exact numeric data type in sql?

0 Answers  

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

---