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

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

What is DCL?

0 Answers  

---

What is the use of RDBMS?

0 Answers   Wipro,

---

How to add a new dsn with the odbc driver for sql server?

0 Answers  

---

How do I schedule a sql server profiler trace?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

What are the differences between local and global temporary tables?

0 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

---

Explain what are commit and rollback in sql?

0 Answers  

---

Can you pass expressions to function parameters?

0 Answers  

---

How to create dbo table in sql server?

0 Answers  

---

How to execute stored procedure in select statement sql server?

0 Answers  

---