Answer / sanjay das

Function allways returns value but stored procedure may or
may not return value.

Answer / viren chakraborty

a stored procedure is better when returning one or more
rows.
a function is better when returning a single scalar value.
function and procedure, both can accept parameters and both
also support output parameters.
for programmers, stored procedures are the way to go
because they directly return the result of a given select
statment.
in a function you will explicitly have to return a value
using return statement and returning more than 1 value
using a function is much more complicated.
the procedure is capable of doing all kinds of things
(select/insert/update/delete) and hence, it is better

Answer / orknob ghosh

Stored procs can't be called within function but function
can be called within stored procedures.

Stored proc can have DML statements whereas a fuction can't

Answer / pandian

1.Stored Procedure WE can call Independ using Exec
statement but function always depend on sql statement

Answer / preetam

Proceudure is pre Compiled Query but function is not

Answer / madhavi latha

stored procedute can return only one integer value.while
function can return more than one value.

we can not use select statement with storedprocedures like
select <spname> where as UDF can.

storedprocedures can not return tables.where as UDF can
return more than one tables.

we can use functions inside the stored procedure but in UDF
we can not use storedprocedures.

Answer / ruchi aggarwal

1.Functions can be used in select, where or case statement
whereas sp cannot.
2.In Functions we cannot modify the base table information.
DML statements cannot be used.
3.In Function non deterministic funstions are not used
whereas we can use them in sps eg:GETDATE
4.No Multiple result sets can be returned from function
whereas we can do this in sp.
5.Error handling is restricted. RAISERROR and @@ERROR are
invalid from inside User Defined Functions

Answer / kautilya

stored procedure can not take paramateres while function
can produce results as per the values passed to it and
functions returns value

Answer / janardan baghla

1.stored proceudures can not return tables whereas
functions can.
2.stored procedures can not used in select statemnet
whereas functions can.

Which control has default post back is enabled(true)?

0 Answers   Sans Pareil IT Services,

What is ispostback method in asp.net? Why do we use that?

0 Answers  

Describe the application event handlers in ASP.NET?

0 Answers   HCL,

In which event are the controls fully loaded?

0 Answers  

is it possible to set more than web.config file for an ASP.net APPLICATION?can it run?how is it possible

3 Answers  

Is asp.net a programming language?

0 Answers  

there is two functions function a and function b like fun a(){.... ..... } fun b() { } in function b i write the coding to add two numbers and i need to dispaly the sum result in function a with out using global variable. how we do?

1 Answers  

if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....

0 Answers   webdirekt,

Hi please tell me what is ISNOTPOSTBACK,POSTBACK,AUTOPOSTBACK and also the extensions of aspx,asmx,ascx its urgent plz reply me soon....

6 Answers   Logica CMG,

when using windows API in .net then it is managed code or Unmanaged code?

2 Answers  

hi i am varinder. i am very eager to learn ASP.net in C#. i am beginer to it. i have refer some books but i found it tuff to understand. their language is tuff. So please tell me the best site or best book to learn ASP.net in C#. i will be very thankful. Varinder

1 Answers  

What is session tracking & methods?

4 Answers   C Squared Systems,