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

What is State Management in .Net and how many ways are there to maintain a state in .Net? What is view state?

1011

---

What is viewstate? In which event of the page life cycle, is the viewstate available?

985

---

Why mvc is faster than asp.net? : Asp.Net MVC

1007

---

What is difference between web config and global asax?

830

---

List some of the important session state modes of asp.net.

951

---

What are the differences between the response.write() and response.output.write()?

970

---

What is the difference between user control and custom control?

900

---

What is the difference between cache and cookies?

964

---

How does asp page work?

941

---

What are the new login controls in asp.net 2.0?

937

---

Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

2103

---

Explain About duration in caching technique

1026

---

Explain the Order of events in an asp.net page?

978

---

What is route in web api?

976

---

What is distributed system in asp.net?

990

---