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

In asp.net application, if a webpage or total application seems too slow or getting delayed to load completely in the browser. As a developer, what are the checkings or actions you will take in the application or server side to rectify the slowness or delay load or which are the factors related to this issue? How we can trace it?

1 Answers  

---

version information of assembly consist of _________ values.

3 Answers   AG Technologies,

---

If we add a textbox and give the required field validator,and i add two radio buttons 1 is yes another one is No.And i add another one server control button ,if i click the button ,if the radio button Yes is checked the validation control is fired ,if no the validation control is not fired.So what you used to solve this problem.

6 Answers   CTS,

---

witch is the best insistute in sharpoint course.what abt future of share point course.

2 Answers  

---

Can we use multiple web.config files in an sigle appliction?

3 Answers   IBS,

---

if you disable view state of a textbox will it maintain data during postbacks.if yes reason

9 Answers   FactorH, Jindal, Oxi Infotech,

---

difference between writing connection string in web.config through connection string and appsettings

2 Answers   iSoft,

---

How many types of Cookies are available in ASP.NET?

0 Answers   MindCracker,

---

we can able to display a MessageBox in asp .net without using any script langages?

8 Answers   ABC,

---

Where code pages are used?

0 Answers   Blue Star,

---

How does VB.NET/C# achieve polymorphism?

6 Answers   Siebel Systems,

---

In which module you have worked in your .net project explain?

1 Answers   TechSolution,

---