摘要
在数据库开发过程中,常会遇到复杂的业务逻辑和数据库操作,这时就需用存储过程来对其进行封装。文章主要对SQLSERVER存储过程进行了简单的概述,提出了创建存储过程的其他方法及注意的问题,并对存储过程的安全性保护以及存储过程的的优化进行了剖析。
In the database development process, often encounter complex business logic and database operations, then use a stored procedure to carry on the package. This paper mainly on the SQL SERVER stored procedures for a simple overview, put forward to create a stored procedure to other methods and pay attention to the problem, and the storage process of security protection and storage process optimization are analyzed.
作者
白杨
BAI Yang (Computer Science and Technology Institute, Hunlunbeier University, Hailaer 021008, China)
出处
《电脑知识与技术》
2011年第12期8769-8770,8776,共3页
Computer Knowledge and Technology