触发器在SQL Server数据库开发中的应用

Application of Triggers in SQL Server Database Development

触发器实际上是一类特殊的存储过程 ,但与一般的存储过程有本质的区别 ,存储过程用户可以调用 ,而触发器不能被调用 ,只有当对表或视图进行一定的触发操作 (INSERT、UPDATE和 DEL ETE)时由系统自动调用。另外触发器不允许带参数 ,和特定的表相关联。并指出了在 SQL

Trigger is in fact a kind of special storage process,but it is different from the common storage process.Users can call the storage process,but trigger can't be called,only when INSERT,UPDATE and DELETE are operated for list and video,the system can automatically calles for.Parameters can't be set in trigger,and trigger is connected with the specific list.The four items in SQL Server database development application are pointed out.