On the Differences and Sameness of View,Stored Procedure and Function in SQL Server

Xibin Sun · Computer Knowledge and Technology · 2011

In the develop of database application system,making reasonable use of View,Stored Procedure and User Defined Function,that can improve the efficiency of develop and optimize the system performance.Introduces the fundamental,such as concept etc,of View,Stored Procedure and User Defined Function in Microsoft SQL Server 2005,combining to the experience of the actual projects,cites the examples of each object,analyses the differences and sameness of View,Stored Procedure and Function by comparing.At last,provides the specific application instances for reference.

Read the paper · More papers on PaperTik