In this article I try to explain the difference between Stored Procedure and Function. I hope after reading this article you will be able to understand BASIC as well as ADVANCE difference between Stored Procedure and Functions (UDF). Comments, criticism and suggestions are always welcome....
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to complete a task, but still there are many differences between Stored procedure and Functions. These differences can be summarized as follows:- 1) A stored procedure can return...
this is another difference between procedure and a function When you create a function ,SQL server will allow you to call a procedure from the Function. However when you execute the function , it will error out with the messgae "Only functions and extended stored procedures can be executed ...
Procedure executes as a part of PL/SQL block wherein Function invoked as part of expression.Function must have RETURN keyword in the header , which is not applicable for Procedure.Function must return a value and could be used in SELECT statement provided that the function doesn't have any D...
I would like to know what is the main difference between View, Procedure and Function? All replies (3) Tuesday, June 22, 2010 2:25 PM |1 vote VIEW A view is a “virtual” table consisting of aSELECTstatement, by means of “virtual” ...
The main difference between procedure and function,function should return a value.procedure need not Was this answer useful? Yes 1 ReplyAntony Gubert Mar 20th, 2006 Ref cursor return type can be used when it's required that a procedure / function need to return set of records. Was ...
- Procedure and function parameters to a procedure are special local variables that can be used to pass values from and to the calling environment, (see:http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html) - Inside a trigger, there are some special local variables that represent th...
C# copy 45 billiow rows from oracle to ms sql C# Copy A File From Resources c# Copy Folder With Progress Bar ? C# Create a txt file into a ftp server C# create dynamic List<string> C# Creating an interface and implementation in shared project c# creating reference between 2 forms c# cry...
2. Transact structured Query language (T-SQL) TSQL stands for Transact structured Query language, which is a Microsoft tool and extension of SQL language. TSQL is mainly used for writing an entire program of block function procedure that defines how things need to be completed and creating an ...
i have some question releated to sql server. please help me to solve it. # What is Difference between Function and Stored Procedure? # What is sub-query & properties of sub-query? # What are primary keys and foreign keys? # What is User Defined Functions? What kind of User-...