SQL Server数据库触发器与存储过程技术在自定义数据表中的应用

Application of SQL Server Database Trigger and Stored Procedure Technologies to User-defined Table

通过对MSSQLServer数据库的触发器和存储过程的介绍 ,并以工资数据表为例详细介绍了在基于客户端 /服务器(Client/Server)结构的MIS系统中利用后台数据库触发器技术和存储过程技术 ,实现自定义数据表 。

This paper first introduces the MS SQL Server database trigger and the stored procedure.Then it takes the salary table as an example to show MIS's utilizing backstage database trigger and stored procedure technologies based on Client/Server to realize the user-defined table.It shows the functions of trigger and stored procedure technologies in correcting the table flexibly.