Answer / dev

Difference between function and stored proc:
========================================================

Stored Procedure :supports deffered name resoultion Example
while writing a stored procedure

that uses table named tabl1 and tabl2 etc..but actually not
exists in database is allowed

only in during creation but runtime throws errorFunction
wont support deffered name

resolution.
2. Stored procedure returns always integer value by default
zero. where as function return

type could be scalar or table or table values(SQL Server).
3. Stored Procedure is pre compiled exuction plan where as
functions are not.
4. Stored Procedure retuns more than one value at a time
while funtion returns only one

value at a time.
5. We can call the functions in sql statements (select max
(sal) from emp). where as sp is

not so
6. Function do not return the images,text whereas sp
returns all.
7. Function and sp both can return the values. But function
returns 1 value only.
procedure can return multiple values(max. 1024) we can
select the fields from function. in

the case of procdure we cannot select the fields.
8. Functions are used for computations where as procedures
can be used for performing

business logic
9. Functions MUST return a value, procedures need not be.
10. You can have DML(insert, update, delete) statements in
a function. But, you cannot call

such a function in a SQL query..eg: suppose, if u have a
function that is updating a table..

you can't call that function in any sql query.
- select myFunction(field) from sometable;
will throw error.
11. Function parameters are always IN, no OUT is possible

Answer / pramod prakash

Function can be used in an expression but we cann't use
procedure in an expression

What is the part of url?

0 Answers  

---

How do you open a page in a new window?

0 Answers  

---

code for inserting images into gridview colomns from database

3 Answers   HP,

---

What is user control in asp.net?

0 Answers  

---

can machine.config file orverrides web.config. For example: if u set session timeout as 30 mins in web.config file to a particular application and if u set session timeout as 10 mins in machin.config. what will happen and which session is set to the appliction?

2 Answers   SunGard,

---

I am using SQLServer 2005. I have one table called Drivers. Every day thousands of records will be added in this table. I have to show all these records in my GridView with out applying ajax timer beacause we don't know the time limit when the new record come to the table. Sometimes it will add for 10 seconds some times 20 seconds. There by Please try without using timer or any other soultion apply for the table in sqlserver. But, i want to see all records immediately when new record comes in table. How? Thanks in advance... Ramesh

5 Answers  

---

What is the difference between server-side scripting and client-side scripting?

0 Answers  

---

What is the difference between session and viewstate in asp.net?

0 Answers  

---

Which is the best institute in Hyderabad/Secunderabad/Andhra Pradesh to learn DotNet?

0 Answers  

---

Is asp.net mvc still used? : Asp.Net MVC

0 Answers  

---

What are generics? why it is used? architecture of ASP.NET?

7 Answers   Path Infotech, Satyam, TCS,

---

What is parse in asp.net?

0 Answers  

---