Answer Posted / 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

what are the critical issues you have resloved in your company

1955

---

How do you delete a data source?

999

---

What are different types of data sources?

1006

---

How would you use user_constraints table in DB?

998

---

Explain about SQL server 2005?

962

---

How to create a simple stored procedure in ms sql server?

1020

---

How can a user-defined datatype be created?

981

---

How to loop through result set objects using odbc_fetch_row()?

964

---

Benefits of Stored Procedures?

962

---

How to delete duplicate rows from table except one?

978

---

What is the default value of an integer data type in sql server 2005?

943

---

How to find which stored procedure is currently running in sql server?

978

---

Which is the main third-party tool used in sql server?

931

---

Define indexes?

1035

---

What is the difference between sdf and mdf?

1294

---