diffrence between function and procedure
Answers were Sorted based on User's Feedback
Answer / srinivas k
Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sakthi
Inside function we cannot able to insert, udate or delete
any record but in procedure we can use it. inside function
we cannot able to call any other functions or procedure but
inside procedure we can call other procedure and functions.
these are the major differences
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pradeep aryan
1. Function can returtn single value but proc san return
multiple values
2. Proc can call a function but function not.
3. function can call in select statement also and acn perform
action also but proc not.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jayanth
Functions always returns a value where as sp performs bath execution
functions can be used along with select statement and where clause where as functions cannot be used with update insert delete statements in which sp cannot be used with select and DML events
functions cannot be used with try catch block where as sp can use try catch block
functions are of two types system functions and user defined functions where as sp's are four types mostly
sp with parameters
sp without parameters
sp with out parameters
sp with return values
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rakesh
function always return value, and procedure not Return the value.
Is This Answer Correct ? | 2 Yes | 3 No |
Explain system scalar functions?
What is the use of custom fields in report?
What is the difference between SQL notification and SQL invalidation?
What are a database and a data warehouse?
List out the difference between union and union all in sql server?
What is the use of partition by in sql server?
What is explicit cursors?
How to fetch the next row from a cursor with a "fetch" statement?
How to move database physical files in ms sql server?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What command do we use to rename a db?
what is memory-optimized nonclustered indexes