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

How to use ipostback?

1000

---

Why web api is better than wcf?

1099

---

Define resource files.

961

---

Can we override the enablepartialrendering property of the scriptmanager class?

1116

---

How we implement web farm and web garden concept in asp.net?

995

---

Write the different features of a Thread and a Process?

1141

---

How can we create Tree control in asp.net?

1031

---

What role “#&&” plays in a querysting?

1012

---

i develop a web application and i gave security setting i.e autherization and athentication now it work properly on my local system , now question is ,is this security setting ie autherization and athentication which i gave in web.config will it be enough strong to secure my application on internet or i have to use some 3rd party tool or software to get security .if yes --how ? if no--what is the alternate?

1957

---

Explain Life cycle of ASP.NET page when a request is made.

1212

---

What are the session management techniques asp net?

991

---

What are the contents of cookie?

1101

---

What is postback and autopostback in asp.net?

1005

---

Differentiate the session object and application object?

935

---

What is event in asp.net?

1005

---