Full-Text Search:
Home|About CNKI|User Service|中文
Add to Favorite Get Latest Update

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

ZHAGN Shen-yong1,CAI Pei-mao1,LIAO Ji-yong2,LE Xiao-yan1,SUN Xi-bin1(1.Zhuhai College of Beijing Institute of Technology,Zhuhai 519085,China;2.Anhui Telecom Planning and Designing CO.LTD,Hefei 230031,China)  
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.
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
©CNKI All Rights Reserved