difference between function and procedure
Answers were Sorted based on User's Feedback
Answer / ramya
1.a function must returns a value where as procedure may not return value
2.a procedure can have parameters of both i/p and o/p but
fun has only i/p parameters
3.in procedure we can perform all the dml operations but in function only select operation should be performed
4.we call a procedure by using 'exec' or 'execute' command where as function is called by using 'select' command
Is This Answer Correct ? | 3 Yes | 1 No |
- Stored Procedures can contain a single SQL statement or a group of SQL statements with data flow control logic containing IF-ELSE, WHILE loop constructs, TRY-CATCH, transactions, etc.
SPs are used to return one or many result-sets to its calling application.
- On the other hand Functions or UDFs can contain single or multiple SQL statements depending on its type. A Scalar UDF & Inline UDF can only have a single SELECT statement. And a Multi-Statement UDF can contain a body with multiple SQL statements including SELECTS, IF-ELSE, WHILE loops and DMLs but limited to manipulating table variables only.
UDFs return a single Scalar value or a Table variable to the calling SELECT statement.
Check all the difference here:
http://sqlwithmanoj.com/2011/09/21/stored-procedures-vs-functions-difference-between-sp-udf/
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ramya gurrala
Functions:1)Do calculations mostly.
2)Must return value.
3)Calling methods.
4)Function can stand alone.
Procedure:1)Do actions mostly.
2)May or may not return value(the return method is not same as function method).
3)Calling methods.
4)Procedure can not stand alone.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the architecture of SQL Server?
How to use union to merge outputs from two queries together in ms sql server?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the Difference beween sql server 2005 and sql server 2008
What is the difference between 2-Tier architecture and 3-Tier architecture
15 Answers CTS, MCN Solutions, Oracle,
Where do you think the users names and passwords will be stored in sql server?
How many index keys possible for a table
What is SQL server agent?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
How can we get count of the number of records in a table?
What are different types of table joins?
What's the purpose of Stored Procedure?