difference between procedure and function

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

difference between procedure and function
Question Posted on 07 Jul 2011

Home >> DataBase >> sql questions >> difference between procedure and function

(1)The major difference between procedure and function is that function return value that should be only single and function can pass any no of parameter but come out only one value only using return statement.
procedure can pass any parameter and came out any no of values there no any RETURN word.
(2)Other difference between procedure and function is that procedure is to be compile only one time. Execution of procedure is faster then function.
(3)Fuction can return a single value only.Stored procedure return more than one value.
(4)Function can be used in select Queries statement but in stored procedure it's not possible.

	0
	0


Input Your Comments Or suggestions(If Any)
Name
Email		(optional)
Comments

Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock

Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions

PHP | Biztalk | Testing | SAP | HR |

Privacy policy | Terms and Conditions | Blog

If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)