|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-stored-procedures-for-beginners/
课程评论：没有评论
**课程名称：** Microsoft SQL 存储过程初学者 **课程概述：** 本课程旨在介绍Microsoft SQL Server中的存储过程，它是一组被分组并存储在数据库中的逻辑单元。存储过程可以接受参数，执行T-SQL语句，并根据需要返回结果集。 **使用存储过程的优势：** * **易于维护：** 无需修改应用程序即可轻松修改存储过程内的代码，且无需重启或重新部署应用程序。 * **减少网络流量：** 使用存储过程代替应用程序级别的T-SQL查询，只需在网络上传递存储过程名称，而非完整的T-SQL代码，从而降低网络负载。 * **可重用性：** 存储过程可以被多个用户或多个客户端应用程序调用，无需重复编写代码。 * **安全性：** 存储过程限制了对表的直接访问，从而降低了安全风险。此外，还可以选择加密存储过程，隐藏其源代码。 * **性能提升：** SQL Server 存储过程在首次执行时会生成执行计划并将其存储在缓冲区中，以便后续执行时能够重复使用，从而提高执行效率。 **课程大纲：** (无)
SQL Server stored procedure is a batch of statements grouped as a logical unit and stored in the database. The stored procedure accepts the parameters and executes the T-SQL statements in the procedure, returns the result set if any.SQL Server stored procedure is a batch of statements grouped as a logical unit and stored in the database. The stored procedure accepts the parameters and executes the T-SQL statements in the procedure, returns the result set if any.Benefits of using a stored procedureWe can easily modify the code inside the stored procedure without the need to restart or deploying the application. Reduced network traffic: When we use stored procedures instead of writing T-SQL queries at the application level, only the procedure name is passed over the network instead of the whole T-SQL code.Reusable: Stored procedures can be executed by multiple users or multiple client applications without the need of writing the code again.Security: Stored procedures reduce the threat by eliminating direct access to the tables. we can also encrypt the stored procedures while creating them so that source code inside the stored procedure is not visible. Performance: The SQL Server stored procedure when executed for the first time creates a plan and stores it in the buffer pool so that the plan can be reused when it executes next time.
