Difference between Function and Procedure-in general?

Answers were Sorted based on User's Feedback



Difference between Function and Procedure-in general?..

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.

Is This Answer Correct ?    28 Yes 6 No

Difference between Function and Procedure-in general?..

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.

Is This Answer Correct ?    13 Yes 2 No

Difference between Function and Procedure-in general?..

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

Is This Answer Correct ?    19 Yes 11 No

Difference between Function and Procedure-in general?..

Answer / arif

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

Is This Answer Correct ?    15 Yes 9 No

Difference between Function and Procedure-in general?..

Answer / rohan

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

Is This Answer Correct ?    9 Yes 6 No

Difference between Function and Procedure-in general?..

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.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More SQL Server Interview Questions

Tell me the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  


How to link tables in sql server?

0 Answers  


What are the system database in sql server 2008?

0 Answers  


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  


Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  






Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  


What are the 10 characteristics of data quality?

0 Answers  


What is thr feature of change data capture?

0 Answers  


Explain having clause and where clause?

0 Answers  


What is @@Identity in sql?

1 Answers   Cap Gemini,


How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,


What happens if null values are involved in datetime operations?

0 Answers  


Categories