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.

How to use subqueries in the from clause in ms sql server?

0 Answers  

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

0 Answers  

Explain data warehousing in sql server?

0 Answers  

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

What is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

How to execute a sql statement using odbc_exec()?

0 Answers  

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

What is an example of a foreign key?

0 Answers  

What is a Stored Procedure?

8 Answers  

explain different types of cursors? : Sql server database administration

0 Answers  

Explain sql delete command?

0 Answers  

Why do we need normalization?

0 Answers