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 |
Differentiate between truncate vs delete in mssql?
Write an sql query to find the names of employees start with ‘a’?
explain different types of jions with examples briefly?
what is web server?
What is resource governor in sql server?
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?
Explain what is analysis service repository?
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?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Are semicolons required at the end of sql statements in sql server 2005?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Show Practically Sql Server Views are updatable?