what is the difference between procedure and function.
Answers were Sorted based on User's Feedback
Answer / plabana
1.StoreProcedure may return avalue may not return a value
but Function returns the value.
2.SttoreProcedure can be called independently using exec
keyword ,Function are called using select stmt.
3.StoreProcedure can create a table but can't return a table
where as Function can return a value.
4.Transaction related stmt can be handeled by StoreProcedure
Where as it can;t be handeled by Function.
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / saraswathi muthuraman
Function :
1) Must return a single value. Only one value can be return
from a function.
2) Can be called from a sql(insert,update,delete) or
assignment st.U can't execute the function directly.
3) Can have DML,DDL,TLC inside function. But those function
can not be called from a sql.
Procedure :
1) Procedure can return multiple values.Procedure is
optional to return a value.
2) Can be executed directly and u can't called procedure
from sql.
3)Can have DML,DDL,TLC inside Procedure.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / hitesh
1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / saurav kumar
1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.
2) Stored proedure may or may not return a value but
function must return a value.
3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.
Is This Answer Correct ? | 0 Yes | 0 No |
Do you know the cursor optimization tips?
What is triggers and stored procedures?
Explain system rowset functions?
How to replace given values with null using nullif()?
Explain the disadvantages/limitation of the cursor?
What do I need to start working with sql studio? : sql server management studio
Can a database be shrunk with users active?
What is service broker? : sql server database administration
what is integrated security (SSPI). why we use in the connection string?
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters
Can we insert data if clustered index is disabled?
What is a transaction and what are ACID properties?
14 Answers Config Systems, IBM, TCS, Virtusa,