Answer / sudhindra

A Function is always returns a value using the return
statement. A Procedure may return one or more values
through parameters or may not return at all.

Answer / dharmendra nonia

Function and Stored Procedure both are precompiled objects
in databases but there is some difference between UDFs and
Stored Procedure such as--
1)Function Must be return at least one value but stored
procedure may or may not.
2)We can use Function for only data manipulation but stored
Procedure is used to Manipulation as well as Modification
of Data on tables.
3)We can't use DML statements inside Function but In stored
Procedure, we can use DML statements.
4)In stored Procedure, we can pass INPUT and OUTPUT
parameter but Function accept only input parameter and
return a value.

Answer / mona

Function can return at most one value at a time while
procedure can return more than one value at a time You can
use function within Sql Statement and you cannot use stored
procedure with in Sql Statement

Answer / arif

function can not have update,delete or insert statement but
Stored procedure can have

Answer / rohan

function can be written in select statement but stored
procedure cannot be written in a select statement

Answer / s.chandrahasan

A stored procedure is like a miniture program in SQL Server.
It can be as simple as a select statement, or as complex as
a long script that adds, deletes, updates, and/or reads data
from multiple tables in a database. (Stored procedures can
also implement loops and cursors which both allow you to
work with smaller results or row by row operations on data.)

The SQL Server functions are option for doing certain
operations in SQL Server. They can not be used to update,
delete, or add records to the database. They simply return a
single value or a table value. They can only be use to
select records. However, they can be called very easily from
within standard SQL, such as:

SELECT dbo.functionname('Parameter1')

OR

SELECT Name, dbo.Functionname('Parameter1') FROM sysObjects

For simple reusable select operations, functions can simply
your code. Just be wary of using JOIN clauses in your
functions. If your function has a JOIN clause and you call
it from another select statement that returns multiple
results, that function call with JOIN those tables together
for EACH line returned in the result set. So though they can
be helpful in simpling some logic, they can also be a
performance bottleneck if they're not used properly.

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

What is create command?

0 Answers  

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

What is nonclustered index with included columns ?

0 Answers  

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

what is difference between primary key and Unique

8 Answers  

How to configure and test odbc dsn settings?

0 Answers  

What is the function of inner join?

0 Answers  

what is Full Text Search ?

1 Answers   TCS,

How do I completely remove sql server instance?

0 Answers  

How to choose all records from the table?

0 Answers  

What is service broker? : sql server database administration

0 Answers